Intro to Data Science - HW 6

Attribution statement: (choose only one and delete the rest)

# 1. I did this homework by myself, with help from the book and the professor.

Last assignment we explored data visualization in R using the ggplot2 package. This homework continues to use ggplot, but this time, with maps. In addition, we will merge datasets using the built-in merge( ) function, which provides a similar capability to a JOIN in SQL (don’t worry if you do not know SQL). Many analytical strategies require joining data from different sources based on a “key” – a field that two datasets have in common.

Step 1: Load the population data

  1. Read the following JSON file, https://intro-datascience.s3.us-east-2.amazonaws.com/cities.json and store it in a variable called pop.

Examine the resulting pop dataframe and add comments explaining what each column contains.

library(tidyverse)
library(jsonlite)
dataset <- url("https://intro-datascience.s3.us-east-2.amazonaws.com/cities.json")
pop <- jsonlite::fromJSON(dataset)
pop
##                             city growth_from_2000_to_2013 latitude  longitude
## 1                       New York                     4.8% 40.71278  -74.00594
## 2                    Los Angeles                     4.8% 34.05223 -118.24368
## 3                        Chicago                    -6.1% 41.87811  -87.62980
## 4                        Houston                    11.0% 29.76043  -95.36980
## 5                   Philadelphia                     2.6% 39.95258  -75.16522
## 6                        Phoenix                    14.0% 33.44838 -112.07404
## 7                    San Antonio                    21.0% 29.42412  -98.49363
## 8                      San Diego                    10.5% 32.71574 -117.16108
## 9                         Dallas                     5.6% 32.77666  -96.79699
## 10                      San Jose                    10.5% 37.33821 -121.88633
## 11                        Austin                    31.7% 30.26715  -97.74306
## 12                  Indianapolis                     7.8% 39.76840  -86.15807
## 13                  Jacksonville                    14.3% 30.33218  -81.65565
## 14                 San Francisco                     7.7% 37.77493 -122.41942
## 15                      Columbus                    14.8% 39.96118  -82.99879
## 16                     Charlotte                    39.1% 35.22709  -80.84313
## 17                    Fort Worth                    45.1% 32.75549  -97.33077
## 18                       Detroit                   -27.1% 42.33143  -83.04575
## 19                       El Paso                    19.4% 31.77758 -106.44246
## 20                       Memphis                    -5.3% 35.14953  -90.04898
## 21                       Seattle                    15.6% 47.60621 -122.33207
## 22                        Denver                    16.7% 39.73924 -104.99025
## 23                    Washington                    13.0% 38.90719  -77.03687
## 24                        Boston                     9.4% 42.36008  -71.05888
## 25            Nashville-Davidson                    16.2% 36.16266  -86.78160
## 26                     Baltimore                    -4.0% 39.29038  -76.61219
## 27                 Oklahoma City                    20.2% 35.46756  -97.51643
## 28   Louisville/Jefferson County                    10.0% 38.25266  -85.75846
## 29                      Portland                    15.0% 45.52306 -122.67648
## 30                     Las Vegas                    24.5% 36.16994 -115.13983
## 31                     Milwaukee                     0.3% 43.03890  -87.90647
## 32                   Albuquerque                    23.5% 35.08533 -106.60555
## 33                        Tucson                     7.5% 32.22174 -110.92648
## 34                        Fresno                    18.3% 36.74684 -119.77259
## 35                    Sacramento                    17.2% 38.58157 -121.49440
## 36                    Long Beach                     1.5% 33.77005 -118.19374
## 37                   Kansas City                     5.5% 39.09973  -94.57857
## 38                          Mesa                    13.5% 33.41518 -111.83147
## 39                Virginia Beach                     5.1% 36.85293  -75.97798
## 40                       Atlanta                     6.2% 33.74900  -84.38798
## 41              Colorado Springs                    21.4% 38.83388 -104.82136
## 42                         Omaha                     5.9% 41.25236  -95.99799
## 43                       Raleigh                    48.7% 35.77959  -78.63818
## 44                         Miami                    14.9% 25.76168  -80.19179
## 45                       Oakland                     1.3% 37.80436 -122.27111
## 46                   Minneapolis                     4.5% 44.97775  -93.26501
## 47                         Tulsa                     1.3% 36.15398  -95.99278
## 48                     Cleveland                   -18.1% 41.49932  -81.69436
## 49                       Wichita                     9.7% 37.68889  -97.33611
## 50                     Arlington                    13.3% 32.73569  -97.10807
## 51                   New Orleans                   -21.6% 29.95107  -90.07153
## 52                   Bakersfield                    48.4% 35.37329 -119.01871
## 53                         Tampa                    16.0% 27.95058  -82.45718
## 54                      Honolulu                    -6.2% 21.30694 -157.85833
## 55                        Aurora                    24.4% 39.72943 -104.83192
## 56                       Anaheim                     4.7% 33.83529 -117.91450
## 57                     Santa Ana                    -1.2% 33.74557 -117.86783
## 58                     St. Louis                    -8.2% 38.62700  -90.19940
## 59                     Riverside                    22.5% 33.95335 -117.39616
## 60                Corpus Christi                    14.1% 27.80058  -97.39638
## 61             Lexington-Fayette                    18.0% 38.04058  -84.50372
## 62                    Pittsburgh                    -8.3% 40.44062  -79.99589
## 63                     Anchorage                    15.4% 61.21806 -149.90028
## 64                      Stockton                    21.8% 37.95770 -121.29078
## 65                    Cincinnati                   -10.1% 39.10312  -84.51202
## 66                      St. Paul                     2.8% 44.95370  -93.08996
## 67                        Toledo                   -10.0% 41.66394  -83.55521
## 68                    Greensboro                    22.3% 36.07264  -79.79198
## 69                        Newark                     2.1% 40.73566  -74.17237
## 70                         Plano                    22.4% 33.01984  -96.69889
## 71                     Henderson                    51.0% 36.03952 -114.98172
## 72                       Lincoln                    18.0% 40.82576  -96.68520
## 73                       Buffalo                   -11.3% 42.88645  -78.87837
## 74                   Jersey City                     7.2% 40.72816  -74.07764
## 75                   Chula Vista                    46.2% 32.64005 -117.08420
## 76                    Fort Wayne                     1.0% 41.07927  -85.13935
## 77                       Orlando                    31.2% 28.53834  -81.37924
## 78                St. Petersburg                     0.3% 27.77306  -82.64000
## 79                      Chandler                    38.7% 33.30616 -111.84125
## 80                        Laredo                    38.2% 27.53057  -99.48032
## 81                       Norfolk                     5.0% 36.85077  -76.28587
## 82                        Durham                    29.9% 35.99403  -78.89862
## 83                       Madison                    15.8% 43.07305  -89.40123
## 84                       Lubbock                    19.6% 33.57786 -101.85517
## 85                        Irvine                    61.3% 33.68395 -117.79469
## 86                 Winston-Salem                    16.9% 36.09986  -80.24422
## 87                      Glendale                     5.7% 33.53865 -112.18599
## 88                       Garland                     8.5% 32.91262  -96.63888
## 89                       Hialeah                     3.2% 25.85760  -80.27811
## 90                          Reno                    26.8% 39.52963 -119.81380
## 91                    Chesapeake                    15.1% 36.76821  -76.28749
## 92                       Gilbert                    96.0% 33.35283 -111.78903
## 93                   Baton Rouge                     0.4% 30.45828  -91.14032
## 94                        Irving                    19.1% 32.81402  -96.94889
## 95                    Scottsdale                    11.0% 33.49417 -111.92605
## 96               North Las Vegas                    92.2% 36.19886 -115.11750
## 97                       Fremont                    10.0% 37.54827 -121.98857
## 98                    Boise City                     9.5% 43.61871 -116.21461
## 99                      Richmond                     8.2% 37.54072  -77.43605
## 100               San Bernardino                    13.0% 34.10834 -117.28977
## 101                   Birmingham                   -12.3% 33.52066  -86.80249
## 102                      Spokane                     7.0% 47.65878 -117.42605
## 103                    Rochester                    -4.1% 43.16103  -77.61092
## 104                   Des Moines                     3.9% 41.60054  -93.60911
## 105                      Modesto                     7.7% 37.63910 -120.99688
## 106                 Fayetteville                     2.4% 35.05266  -78.87836
## 107                       Tacoma                     4.9% 47.25288 -122.44429
## 108                       Oxnard                    18.2% 34.19750 -119.17705
## 109                      Fontana                    38.3% 34.09223 -117.43505
## 110                     Columbus                     8.7% 32.46098  -84.98771
## 111                   Montgomery                    -0.1% 32.36681  -86.29997
## 112                Moreno Valley                    40.4% 33.94247 -117.22967
## 113                   Shreveport                    -0.1% 32.52515  -93.75018
## 114                       Aurora                    38.4% 41.76058  -88.32007
## 115                      Yonkers                     1.8% 40.93121  -73.89875
## 116                        Akron                    -8.6% 41.08144  -81.51901
## 117             Huntington Beach                     3.9% 33.66030 -117.99923
## 118                  Little Rock                     7.6% 34.74648  -92.28959
## 119      Augusta-Richmond County                     1.1% 33.47350  -82.01051
## 120                     Amarillo                    12.8% 35.22200 -101.83130
## 121                     Glendale                     0.3% 34.14251 -118.25508
## 122                       Mobile                    -1.9% 30.69537  -88.03989
## 123                 Grand Rapids                    -2.8% 42.96336  -85.66809
## 124               Salt Lake City                     5.1% 40.76078 -111.89105
## 125                  Tallahassee                    21.8% 30.43826  -84.28073
## 126                   Huntsville                    16.3% 34.73037  -86.58610
## 127                Grand Prairie                    43.1% 32.74596  -96.99778
## 128                    Knoxville                     3.9% 35.96064  -83.92074
## 129                    Worcester                     5.8% 42.26259  -71.80229
## 130                 Newport News                     0.9% 37.08708  -76.47301
## 131                  Brownsville                    26.8% 25.90175  -97.49748
## 132                Overland Park                    19.4% 38.98223  -94.67079
## 133                Santa Clarita                    15.3% 34.39166 -118.54259
## 134                   Providence                     2.3% 41.82399  -71.41283
## 135                 Garden Grove                     5.8% 33.77391 -117.94145
## 136                  Chattanooga                    10.5% 35.04563  -85.30968
## 137                    Oceanside                     6.6% 33.19587 -117.37948
## 138                      Jackson                    -6.8% 32.29876  -90.18481
## 139              Fort Lauderdale                     0.7% 26.12244  -80.13732
## 140                   Santa Rosa                    15.2% 38.44043 -122.71405
## 141             Rancho Cucamonga                    32.7% 34.10640 -117.59311
## 142               Port St. Lucie                    91.7% 27.27305  -80.35823
## 143                        Tempe                     5.8% 33.42551 -111.94001
## 144                      Ontario                     5.5% 34.06334 -117.65089
## 145                    Vancouver                    14.2% 45.63873 -122.66149
## 146                   Cape Coral                    60.4% 26.56285  -81.94953
## 147                  Sioux Falls                    31.1% 43.54460  -96.73110
## 148                  Springfield                     7.8% 37.20896  -93.29230
## 149                       Peoria                    46.5% 33.58060 -112.23738
## 150               Pembroke Pines                    17.4% 26.00776  -80.29626
## 151                    Elk Grove                    97.1% 38.40880 -121.37162
## 152                        Salem                    16.4% 44.94290 -123.03510
## 153                    Lancaster                    33.8% 34.68678 -118.15416
## 154                       Corona                    23.6% 33.87529 -117.56644
## 155                       Eugene                    14.4% 44.05207 -123.08675
## 156                     Palmdale                    33.7% 34.57943 -118.11646
## 157                      Salinas                     8.4% 36.67774 -121.65550
## 158                  Springfield                     1.1% 42.10148  -72.58981
## 159                     Pasadena                     7.5% 29.69106  -95.20910
## 160                 Fort Collins                    26.6% 40.58526 -105.08442
## 161                      Hayward                     7.5% 37.66882 -122.08080
## 162                       Pomona                     2.1% 34.05510 -117.74999
## 163                         Cary                    55.1% 35.79154  -78.78112
## 164                     Rockford                    -1.0% 42.27113  -89.09400
## 165                   Alexandria                    15.0% 38.80484  -77.04692
## 166                    Escondido                    10.7% 33.11921 -117.08642
## 167                     McKinney                   165.3% 33.19725  -96.63978
## 168                  Kansas City                     1.1% 39.11405  -94.62746
## 169                       Joliet                    36.5% 41.52503  -88.08173
## 170                    Sunnyvale                    11.9% 37.36883 -122.03635
## 171                     Torrance                     6.6% 33.83585 -118.34063
## 172                   Bridgeport                     5.4% 41.18655  -73.19518
## 173                     Lakewood                     1.9% 39.70471 -105.08137
## 174                    Hollywood                     4.8% 26.01120  -80.14949
## 175                     Paterson                    -2.2% 40.91677  -74.17181
## 176                   Naperville                    12.0% 41.75084  -88.15354
## 177                     Syracuse                    -0.9% 43.04812  -76.14742
## 178                     Mesquite                    14.7% 32.76680  -96.59916
## 179                       Dayton                   -13.5% 39.75895  -84.19161
## 180                     Savannah                     7.5% 32.08354  -81.09983
## 181                  Clarksville                    36.9% 36.52977  -87.35945
## 182                       Orange                     7.7% 33.78779 -117.85311
## 183                     Pasadena                     3.8% 34.14778 -118.14452
## 184                    Fullerton                     9.8% 33.87036 -117.92430
## 185                      Killeen                    52.1% 31.11712  -97.72780
## 186                       Frisco                   287.7% 33.15067  -96.82361
## 187                      Hampton                    -6.6% 37.02987  -76.34522
## 188                      McAllen                    27.6% 26.20341  -98.23001
## 189                       Warren                    -2.3% 42.51446  -83.01465
## 190                     Bellevue                    19.1% 47.61038 -122.20068
## 191             West Valley City                    22.2% 40.69161 -112.00105
## 192                     Columbia                    11.7% 34.00071  -81.03481
## 193                       Olathe                    40.4% 38.88140  -94.81913
## 194             Sterling Heights                     5.2% 42.58031  -83.03020
## 195                    New Haven                     5.5% 41.30827  -72.92788
## 196                      Miramar                    74.7% 25.98608  -80.30356
## 197                         Waco                    12.5% 31.54933  -97.14667
## 198                Thousand Oaks                     9.5% 34.17056 -118.83759
## 199                 Cedar Rapids                     5.4% 41.97788  -91.66562
## 200                   Charleston                    29.2% 32.77647  -79.93105
## 201                      Visalia                    33.6% 36.33023 -119.29206
## 202                       Topeka                     3.4% 39.05582  -95.68902
## 203                    Elizabeth                     5.5% 40.66399  -74.21070
## 204                  Gainesville                    12.8% 29.65163  -82.32483
## 205                     Thornton                    52.9% 39.86804 -104.97192
## 206                    Roseville                    56.2% 38.75212 -121.28801
## 207                   Carrollton                    14.9% 32.97564  -96.88996
## 208                Coral Springs                     5.7% 26.27119  -80.27060
## 209                     Stamford                     7.6% 41.05343  -73.53873
## 210                  Simi Valley                    12.6% 34.26945 -118.78148
## 211                      Concord                     2.9% 37.97798 -122.03107
## 212                     Hartford                     0.6% 41.76371  -72.68509
## 213                         Kent                    54.3% 47.38093 -122.23484
## 214                    Lafayette                    11.0% 30.22409  -92.01984
## 215                      Midland                    30.4% 31.99735 -102.07791
## 216                     Surprise                   281.9% 33.62923 -112.36793
## 217                       Denton                    47.1% 33.21484  -97.13307
## 218                  Victorville                    87.6% 34.53622 -117.29276
## 219                   Evansville                    -0.8% 37.97156  -87.57109
## 220                  Santa Clara                    17.4% 37.35411 -121.95524
## 221                      Abilene                     3.6% 32.44874  -99.73314
## 222         Athens-Clarke County                    19.0% 33.95193  -83.35757
## 223                      Vallejo                     1.2% 38.10409 -122.25664
## 224                    Allentown                    11.2% 40.60843  -75.49018
## 225                       Norman                    22.0% 35.22257  -97.43948
## 226                     Beaumont                     3.7% 30.08017  -94.12656
## 227                 Independence                     3.2% 39.09112  -94.41551
## 228                 Murfreesboro                    65.1% 35.84562  -86.39027
## 229                    Ann Arbor                     2.0% 42.28083  -83.74304
## 230                  Springfield                     4.2% 39.78172  -89.65015
## 231                     Berkeley                    13.3% 37.87159 -122.27275
## 232                       Peoria                     3.0% 40.69365  -89.58899
## 233                        Provo                    10.0% 40.23384 -111.65853
## 234                     El Monte                    -0.4% 34.06862 -118.02757
## 235                     Columbia                    34.0% 38.95171  -92.33407
## 236                      Lansing                    -4.4% 42.73253  -84.55553
## 237                        Fargo                    24.9% 46.87719  -96.78980
## 238                       Downey                     5.3% 33.94011 -118.13316
## 239                   Costa Mesa                     2.4% 33.64113 -117.91867
## 240                   Wilmington                    24.8% 34.22573  -77.94471
## 241                       Arvada                     9.2% 39.80276 -105.08748
## 242                    Inglewood                    -1.0% 33.96168 -118.35313
## 243                Miami Gardens                    10.5% 25.94204  -80.24560
## 244                     Carlsbad                    39.7% 33.15809 -117.35059
## 245                  Westminster                     9.4% 39.83665 -105.03720
## 246                    Rochester                    23.9% 44.01212  -92.48020
## 247                       Odessa                    22.3% 31.84568 -102.36764
## 248                   Manchester                     2.9% 42.99564  -71.45479
## 249                        Elgin                    16.0% 42.03541  -88.28257
## 250                  West Jordan                    38.4% 40.60967 -111.93910
## 251                   Round Rock                    81.0% 30.50826  -97.67890
## 252                   Clearwater                     0.1% 27.96585  -82.80010
## 253                    Waterbury                     2.2% 41.55815  -73.05150
## 254                      Gresham                    20.7% 45.50014 -122.43020
## 255                    Fairfield                    12.8% 38.24936 -122.03997
## 256                     Billings                    18.6% 45.78329 -108.50069
## 257                       Lowell                     3.4% 42.63342  -71.31617
## 258   San Buenaventura (Ventura)                     7.4% 34.27465 -119.22903
## 259                       Pueblo                     5.9% 38.25445 -104.60914
## 260                   High Point                    24.3% 35.95569  -80.00532
## 261                  West Covina                     2.3% 34.06862 -117.93895
## 262                     Richmond                     7.9% 37.93576 -122.34775
## 263                     Murrieta                   107.4% 33.55391 -117.21392
## 264                    Cambridge                     5.5% 42.37362  -71.10973
## 265                      Antioch                    16.9% 38.00492 -121.80579
## 266                     Temecula                    55.4% 33.49364 -117.14836
## 267                      Norwalk                     1.9% 33.90224 -118.08173
## 268                   Centennial                     3.5% 39.58075 -104.87717
## 269                      Everett                     9.4% 47.97898 -122.20208
## 270                     Palm Bay                    31.7% 28.03446  -80.58866
## 271                Wichita Falls                     0.7% 33.91371  -98.49339
## 272                    Green Bay                     1.9% 44.51916  -88.01983
## 273                    Daly City                     1.0% 37.68792 -122.47021
## 274                      Burbank                     4.2% 34.18084 -118.30897
## 275                   Richardson                    13.2% 32.94833  -96.72985
## 276                Pompano Beach                     4.0% 26.23786  -80.12477
## 277             North Charleston                    27.4% 32.85462  -79.97481
## 278                 Broken Arrow                    28.2% 36.06095  -95.79745
## 279                      Boulder                     9.0% 40.01499 -105.27055
## 280              West Palm Beach                    23.5% 26.71534  -80.05337
## 281                  Santa Maria                    30.9% 34.95303 -120.43572
## 282                     El Cajon                     7.4% 32.79477 -116.96253
## 283                    Davenport                     3.9% 41.52364  -90.57764
## 284                       Rialto                     9.8% 34.10640 -117.37032
## 285                   Las Cruces                    37.6% 32.31994 -106.76365
## 286                    San Mateo                     9.0% 37.56299 -122.32553
## 287                   Lewisville                    28.9% 33.04623  -96.99417
## 288                   South Bend                    -6.8% 41.67635  -86.25199
## 289                     Lakeland                    18.3% 28.03947  -81.94980
## 290                         Erie                    -2.8% 42.12922  -80.08506
## 291                        Tyler                    18.6% 32.35126  -95.30106
## 292                     Pearland                   117.2% 29.56357  -95.28605
## 293              College Station                    45.2% 30.62798  -96.33441
## 294                      Kenosha                     9.5% 42.58474  -87.82119
## 295                Sandy Springs                    17.4% 33.93044  -84.37331
## 296                       Clovis                    42.6% 36.82523 -119.70292
## 297                        Flint                   -20.0% 43.01253  -83.68746
## 298                      Roanoke                     3.8% 37.27097  -79.94143
## 299                       Albany                     4.1% 42.65258  -73.75623
## 300                Jurupa Valley                          33.99720 -117.48548
## 301                      Compton                     4.5% 33.89585 -118.22007
## 302                   San Angelo                    10.2% 31.46377 -100.43704
## 303                    Hillsboro                    36.4% 45.52289 -122.98983
## 304                       Lawton                     4.9% 34.60357  -98.39593
## 305                       Renton                    88.4% 47.48288 -122.21707
## 306                        Vista                     7.7% 33.20004 -117.24254
## 307                        Davie                    17.7% 26.07648  -80.25212
## 308                      Greeley                    23.1% 40.42331 -104.70913
## 309                Mission Viejo                     2.9% 33.60002 -117.67200
## 310                   Portsmouth                    -4.2% 36.83543  -76.29827
## 311                     Dearborn                    -2.0% 42.32226  -83.17631
## 312                   South Gate                    -0.8% 33.95474 -118.21202
## 313                   Tuscaloosa                    21.1% 33.20984  -87.56917
## 314                      Livonia                    -5.4% 42.36837  -83.35271
## 315                  New Bedford                     1.2% 41.63622  -70.93420
## 316                    Vacaville                     5.4% 38.35658 -121.98774
## 317                     Brockton                    -0.3% 42.08343  -71.01838
## 318                      Roswell                    15.2% 34.02324  -84.36156
## 319                    Beaverton                    17.0% 45.48706 -122.80371
## 320                       Quincy                     5.8% 42.25288  -71.00227
## 321                       Sparks                    39.4% 39.53491 -119.75269
## 322                       Yakima                    11.7% 46.60207 -120.50590
## 323                 Lee's Summit                    31.2% 38.91084  -94.38217
## 324                  Federal Way                     8.8% 47.32232 -122.31262
## 325                       Carson                     2.9% 33.83167 -118.28169
## 326                 Santa Monica                     9.6% 34.01945 -118.49119
## 327                     Hesperia                    46.1% 34.42639 -117.30088
## 328                        Allen                   104.0% 33.10317  -96.67055
## 329                   Rio Rancho                    74.4% 35.23275 -106.66304
## 330                         Yuma                    16.2% 32.69265 -114.62769
## 331                  Westminster                     3.9% 33.75134 -117.99399
## 332                         Orem                     8.5% 40.29690 -111.69465
## 333                         Lynn                     2.6% 42.46676  -70.94949
## 334                      Redding                    11.9% 40.58654 -122.39168
## 335               Spokane Valley                    12.6% 47.67323 -117.23937
## 336                  Miami Beach                     3.3% 25.79065  -80.13005
## 337                  League City                    98.3% 29.50745  -95.09493
## 338                     Lawrence                    12.7% 38.97167  -95.23525
## 339                Santa Barbara                     0.9% 34.42083 -119.69819
## 340                   Plantation                     8.6% 26.12759  -80.23310
## 341                        Sandy                     1.3% 40.56498 -111.83897
## 342                      Sunrise                     4.6% 26.16697  -80.25659
## 343                        Macon                    -7.3% 32.84069  -83.63240
## 344                     Longmont                    24.4% 40.16721 -105.10193
## 345                   Boca Raton                     7.5% 26.36831  -80.12893
## 346                   San Marcos                    60.0% 33.14337 -117.16614
## 347                   Greenville                    41.9% 35.61266  -77.36635
## 348                     Waukegan                     0.5% 42.36363  -87.84479
## 349                   Fall River                    -3.7% 41.70149  -71.15505
## 350                        Chico                    14.2% 39.72849 -121.83748
## 351                       Newton                     4.9% 42.33704  -71.20922
## 352                  San Leandro                    10.3% 37.72493 -122.15608
## 353                      Reading                     8.0% 40.33565  -75.92687
## 354                      Norwalk                     5.6% 41.11774  -73.40816
## 355                   Fort Smith                     8.6% 35.38592  -94.39855
## 356                Newport Beach                    10.4% 33.61891 -117.92895
## 357                    Asheville                    19.6% 35.59506  -82.55149
## 358                       Nashua                     0.4% 42.76537  -71.46757
## 359                       Edmond                    26.9% 35.65283  -97.47810
## 360                     Whittier                     3.3% 33.97918 -118.03284
## 361                        Nampa                    57.9% 43.54072 -116.56346
## 362                  Bloomington                     1.3% 44.84080  -93.29828
## 363                      Deltona                    23.1% 28.90054  -81.26367
## 364                    Hawthorne                     2.3% 33.91640 -118.35257
## 365                       Duluth                    -0.1% 46.78667  -92.10049
## 366                       Carmel                    60.4% 39.97837  -86.11804
## 367                      Suffolk                    33.5% 36.72821  -76.58356
## 368                      Clifton                     7.9% 40.85843  -74.16376
## 369               Citrus Heights                    -0.1% 38.70712 -121.28106
## 370                    Livermore                    15.1% 37.68187 -121.76801
## 371                        Tracy                    45.9% 37.73965 -121.42522
## 372                     Alhambra                    -0.7% 34.09529 -118.12701
## 373                     Kirkland                    87.5% 47.68149 -122.20874
## 374                      Trenton                    -1.2% 40.21705  -74.74294
## 375                        Ogden                     8.6% 41.22300 -111.97383
## 376                       Hoover                    32.7% 33.40539  -86.81138
## 377                       Cicero                    -1.6% 41.84559  -87.75394
## 378                      Fishers                   114.8% 39.95675  -86.01335
## 379                   Sugar Land                    29.1% 29.61968  -95.63495
## 380                      Danbury                    11.4% 41.39482  -73.45401
## 381                     Meridian                   127.6% 43.61211 -116.39151
## 382                        Indio                    66.0% 33.72058 -116.21556
## 383                      Concord                    47.4% 35.40875  -80.57951
## 384                      Menifee                    95.0% 33.69715 -117.18529
## 385                    Champaign                    18.3% 40.11642  -88.24338
## 386                   Buena Park                     6.1% 33.86751 -117.99812
## 387                         Troy                     2.2% 42.60641  -83.14978
## 388                     O'Fallon                    62.6% 38.81061  -90.69985
## 389                  Johns Creek                    36.5% 34.02893  -84.19858
## 390                   Bellingham                    21.8% 48.74908 -122.47815
## 391                     Westland                    -4.7% 42.32420  -83.40021
## 392                  Bloomington                    16.1% 39.16533  -86.52639
## 393                   Sioux City                    -2.9% 42.49999  -96.40031
## 394                      Warwick                    -4.6% 41.70010  -71.41617
## 395                        Hemet                    37.6% 33.74752 -116.97197
## 396                     Longview                    11.6% 32.50070  -94.74049
## 397             Farmington Hills                    -0.9% 42.49899  -83.36772
## 398                         Bend                    54.3% 44.05817 -121.31531
## 399                     Lakewood                     2.1% 33.85363 -118.13396
## 400                       Merced                    25.4% 37.30216 -120.48297
## 401                      Mission                    74.5% 26.21591  -98.32529
## 402                        Chino                    15.6% 34.01223 -117.68894
## 403                 Redwood City                     7.1% 37.48522 -122.23635
## 404                     Edinburg                    65.1% 26.30174  -98.16334
## 405                     Cranston                     1.4% 41.77982  -71.43728
## 406                        Parma                    -5.9% 41.40477  -81.72291
## 407                 New Rochelle                     9.9% 40.91149  -73.78235
## 408                  Lake Forest                     4.2% 33.64697 -117.68922
## 409                         Napa                     8.4% 38.29754 -122.28687
## 410                      Hammond                    -4.6% 41.58337  -87.50004
## 411                 Fayetteville                    32.9% 36.06258  -94.15743
## 412                  Bloomington                    20.1% 40.48420  -88.99369
## 413                     Avondale                   111.5% 33.43560 -112.34960
## 414                   Somerville                     1.6% 42.38760  -71.09950
## 415                   Palm Coast                   137.2% 29.58445  -81.20787
## 416                        Bryan                    19.3% 30.67436  -96.36996
## 417                         Gary                   -23.4% 41.59337  -87.34643
## 418                        Largo                     5.1% 27.90947  -82.78732
## 419                Brooklyn Park                    16.0% 45.09413  -93.35634
## 420                       Tustin                    15.6% 33.74585 -117.82617
## 421                       Racine                    -4.4% 42.72613  -87.78285
## 422              Deerfield Beach                     4.8% 26.31841  -80.09977
## 423                    Lynchburg                    19.5% 37.41375  -79.14225
## 424                Mountain View                    10.1% 37.38605 -122.08385
## 425                      Medford                    17.1% 42.32652 -122.87559
## 426                     Lawrence                     7.5% 42.70704  -71.16311
## 427                   Bellflower                     6.3% 33.88168 -118.11701
## 428                    Melbourne                     5.9% 28.08363  -80.60811
## 429                   St. Joseph                     4.1% 39.76746  -94.84668
## 430                       Camden                    -3.6% 39.92595  -75.11962
## 431                   St. George                    53.1% 37.09653 -113.56842
## 432                    Kennewick                    29.1% 46.21125 -119.13723
## 433                 Baldwin Park                     0.8% 34.08529 -117.96090
## 434                  Chino Hills                    13.6% 33.98982 -117.73258
## 435                      Alameda                     5.4% 37.76521 -122.24164
## 436                       Albany                    -0.6% 31.57851  -84.15574
## 437            Arlington Heights                    -0.6% 42.08836  -87.98063
## 438                     Scranton                     0.0% 41.40897  -75.66241
## 439                     Evanston                     1.9% 42.04507  -87.68770
## 440                    Kalamazoo                    -1.9% 42.29171  -85.58723
## 441                      Baytown                    13.1% 29.73550  -94.97743
## 442                       Upland                     9.5% 34.09751 -117.64839
## 443                   Springdale                    57.1% 36.18674  -94.12881
## 444                    Bethlehem                     5.2% 40.62593  -75.37046
## 445                   Schaumburg                    -0.5% 42.03336  -88.08341
## 446               Mount Pleasant                    53.2% 32.83232  -79.82843
## 447                       Auburn                    34.9% 47.30732 -122.22845
## 448                      Decatur                    -8.7% 39.84031  -88.95480
## 449                    San Ramon                    65.8% 37.77993 -121.97802
## 450                   Pleasanton                    15.2% 37.66243 -121.87468
## 451                      Wyoming                     6.5% 42.91336  -85.70531
## 452                 Lake Charles                     3.0% 30.22659  -93.21738
## 453                     Plymouth                    12.0% 45.01052  -93.45551
## 454                  Bolingbrook                    29.7% 41.69864  -88.06840
## 455                        Pharr                    55.7% 26.19480  -98.18362
## 456                     Appleton                     4.5% 44.26193  -88.41538
## 457                     Gastonia                     8.2% 35.26208  -81.18730
## 458                       Folsom                    38.6% 38.67796 -121.17606
## 459                   Southfield                    -6.7% 42.47337  -83.22187
## 460              Rochester Hills                     5.7% 42.65837  -83.14993
## 461                  New Britain                     1.9% 41.66121  -72.77954
## 462                     Goodyear                   271.0% 33.43534 -112.35766
## 463                       Canton                   -10.3% 40.79895  -81.37845
## 464                Warner Robins                    45.7% 32.61300  -83.62420
## 465                   Union City                     7.4% 37.59339 -122.04383
## 466                       Perris                    98.7% 33.78252 -117.22865
## 467                      Manteca                    42.7% 37.79743 -121.21605
## 468                    Iowa City                    13.8% 41.66113  -91.53017
## 469                    Jonesboro                    28.3% 35.84230  -90.70428
## 470                   Wilmington                    -1.6% 39.73907  -75.53979
## 471                      Lynwood                     2.0% 33.93029 -118.21146
## 472                     Loveland                    37.4% 40.39776 -105.07498
## 473                    Pawtucket                    -2.5% 41.87871  -71.38256
## 474                Boynton Beach                    17.3% 26.53179  -80.09055
## 475                     Waukesha                     8.0% 43.01168  -88.23148
## 476                     Gulfport                    -0.6% 30.36742  -89.09282
## 477                 Apple Valley                    29.9% 34.50083 -117.18588
## 478                      Passaic                     4.3% 40.85677  -74.12848
## 479                   Rapid City                    17.9% 44.08054 -103.23101
## 480                       Layton                    20.2% 41.06022 -111.97105
## 481                    Lafayette                    14.5% 40.41670  -86.87529
## 482                      Turlock                    23.5% 37.49466 -120.84659
## 483                       Muncie                    -0.7% 40.19338  -85.38636
## 484                       Temple                    27.1% 31.09823  -97.34278
## 485                Missouri City                    31.1% 29.61857  -95.53772
## 486                     Redlands                     9.4% 34.05557 -117.18254
## 487                     Santa Fe                    10.5% 35.68698 -105.93780
## 488                   Lauderhill                     4.2% 26.14036  -80.21338
## 489                     Milpitas                    11.0% 37.43233 -121.89957
## 490                     Palatine                     4.5% 42.11030  -88.03424
## 491                     Missoula                    19.7% 46.87872 -113.99659
## 492                    Rock Hill                    36.0% 34.92487  -81.02508
## 493                 Jacksonville                     5.0% 34.75405  -77.43024
## 494                     Franklin                    48.5% 35.92506  -86.86889
## 495                    Flagstaff                    29.3% 35.19828 -111.65130
## 496                 Flower Mound                    32.5% 33.01457  -97.09696
## 497                       Weston                    34.5% 26.10037  -80.39977
## 498                     Waterloo                    -0.5% 42.49279  -92.34258
## 499                   Union City                     1.7% 40.69759  -74.26316
## 500                 Mount Vernon                    -0.2% 40.91260  -73.83708
## 501                   Fort Myers                    31.2% 26.64063  -81.87231
## 502                       Dothan                    16.6% 31.22323  -85.39049
## 503               Rancho Cordova                    26.4% 38.58907 -121.30273
## 504                Redondo Beach                     6.7% 33.84918 -118.38841
## 505                      Jackson                    12.9% 35.61452  -88.81395
## 506                        Pasco                    98.5% 46.23958 -119.10057
## 507                  St. Charles                    11.3% 38.78811  -90.49744
## 508                   Eau Claire                     8.7% 44.81135  -91.49849
## 509         North Richland Hills                    20.2% 32.83430  -97.22890
## 510                     Bismarck                    20.1% 46.80833 -100.78374
## 511                  Yorba Linda                    13.4% 33.88863 -117.81311
## 512                       Kenner                    -4.8% 29.99409  -90.24174
## 513                 Walnut Creek                     3.5% 37.91008 -122.06518
## 514                    Frederick                    25.9% 39.41427  -77.41054
## 515                      Oshkosh                     5.3% 44.02471  -88.54261
## 516                    Pittsburg                    16.6% 38.02798 -121.88468
## 517                    Palo Alto                    13.7% 37.44188 -122.14302
## 518                 Bossier City                    17.4% 32.51599  -93.73212
## 519                     Portland                     3.2% 43.66147  -70.25533
## 520                    St. Cloud                    10.9% 45.55795  -94.16324
## 521                        Davis                    11.9% 38.54491 -121.74052
## 522          South San Francisco                     9.1% 37.65466 -122.40775
## 523                    Camarillo                    14.9% 34.21639 -119.03760
## 524            North Little Rock                     9.0% 34.76954  -92.26709
## 525                  Schenectady                     6.7% 42.81424  -73.93957
## 526                 Gaithersburg                    24.2% 39.14344  -77.20137
## 527                    Harlingen                    11.6% 26.19063  -97.69610
## 528                     Woodbury                    39.8% 44.92386  -92.95938
## 529                        Eagan                     2.6% 44.80413  -93.16689
## 530                    Yuba City                    27.9% 39.14045 -121.61691
## 531                  Maple Grove                    27.3% 45.07246  -93.45579
## 532                   Youngstown                   -20.2% 41.09978  -80.64952
## 533                       Skokie                     2.8% 42.03240  -87.74162
## 534                    Kissimmee                    32.6% 28.29196  -81.40757
## 535                 Johnson City                    16.2% 36.31344  -82.35347
## 536                     Victoria                     7.5% 28.80527  -97.00360
## 537                 San Clemente                    28.6% 33.42697 -117.61199
## 538                      Bayonne                     5.1% 40.66871  -74.11431
## 539                Laguna Niguel                     2.8% 33.52253 -117.70755
## 540                  East Orange                    -7.4% 40.76732  -74.20487
## 541                      Shawnee                    32.2% 39.02285  -94.71519
## 542                    Homestead                   100.7% 25.46872  -80.47756
## 543                    Rockville                    34.0% 39.08400  -77.15276
## 544                 Delray Beach                     6.1% 26.46146  -80.07282
## 545                   Janesville                     5.6% 42.68279  -89.01872
## 546                       Conway                    46.1% 35.08870  -92.44210
## 547                  Pico Rivera                     0.4% 33.98307 -118.09673
## 548                       Lorain                    -7.2% 41.45282  -82.18237
## 549                   Montebello                     2.0% 34.01651 -118.11375
## 550                         Lodi                    10.1% 38.13415 -121.27222
## 551                New Braunfels                    64.0% 29.70300  -98.12445
## 552                   Marysville                   115.7% 48.05176 -122.17708
## 553                      Tamarac                    12.9% 26.21286  -80.24977
## 554                       Madera                    44.4% 36.96134 -120.06072
## 555                       Conroe                    61.9% 30.31188  -95.45605
## 556                   Santa Cruz                    12.5% 36.97412 -122.03080
## 557                 Eden Prairie                    13.3% 44.85469  -93.47079
## 558                     Cheyenne                    16.9% 41.13998 -104.82025
## 559                Daytona Beach                    -2.3% 29.21081  -81.02283
## 560                   Alpharetta                    33.6% 34.07538  -84.29409
## 561                     Hamilton                     2.7% 39.39950  -84.56134
## 562                      Waltham                     5.0% 42.37649  -71.23561
## 563                  Coon Rapids                     0.6% 45.17324  -93.30301
## 564                    Haverhill                     5.0% 42.77620  -71.07728
## 565               Council Bluffs                     6.2% 41.26194  -95.86083
## 566                       Taylor                    -6.3% 42.24087  -83.26965
## 567                        Utica                     2.2% 43.10090  -75.23266
## 568                         Ames                    21.3% 42.03472  -93.62000
## 569                     La Habra                     3.6% 33.93196 -117.94617
## 570                    Encinitas                     5.8% 33.03699 -117.29198
## 571                Bowling Green                    24.1% 36.96852  -86.48080
## 572                   Burnsville                     1.9% 44.76774  -93.27772
## 573                   Greenville                     8.2% 34.85262  -82.39401
## 574              West Des Moines                    29.8% 41.57721  -93.71133
## 575                   Cedar Park                   134.3% 30.50520  -97.82029
## 576                       Tulare                    33.3% 36.20773 -119.34734
## 577                Monterey Park                     1.5% 34.06251 -118.12285
## 578                     Vineland                     9.3% 39.48638  -75.02596
## 579                  Terre Haute                     2.5% 39.46670  -87.41391
## 580                  North Miami                     2.0% 25.89009  -80.18671
## 581                    Mansfield                   114.2% 32.56319  -97.14168
## 582                   West Allis                    -0.6% 43.01668  -88.00703
## 583                      Bristol                     0.4% 41.67176  -72.94927
## 584                 Taylorsville                     2.9% 40.66772 -111.93883
## 585                       Malden                     7.4% 42.42510  -71.06616
## 586                      Meriden                     3.7% 41.53815  -72.80704
## 587                       Blaine                    32.8% 45.16080  -93.23495
## 588                   Wellington                    55.0% 26.66176  -80.26836
## 589                    Cupertino                    14.3% 37.32300 -122.03218
## 590                  Springfield                    12.4% 44.04624 -123.02203
## 591                       Rogers                    50.6% 36.33202  -94.11854
## 592             St. Clair Shores                    -4.6% 42.49741  -82.89636
## 593                      Gardena                     3.4% 33.88835 -118.30896
## 594                      Pontiac                   -11.4% 42.63892  -83.29105
## 595                National City                    10.1% 32.67811 -117.09920
## 596               Grand Junction                    30.9% 39.06387 -108.55065
## 597                      Rocklin                    60.3% 38.79073 -121.23578
## 598                  Chapel Hill                    24.1% 35.91320  -79.05584
## 599                       Casper                    19.9% 42.86663 -106.31308
## 600                   Broomfield                    50.3% 39.92054 -105.08665
## 601                     Petaluma                     8.4% 38.23242 -122.63665
## 602                 South Jordan                   100.1% 40.56217 -111.92966
## 603                  Springfield                    -9.8% 39.92423  -83.80882
## 604                  Great Falls                     3.9% 47.49418 -111.28334
## 605                    Lancaster                     4.5% 40.03788  -76.30551
## 606                   North Port                   154.6% 27.04422  -82.23593
## 607                     Lakewood                     1.1% 47.17176 -122.51846
## 608                     Marietta                    -3.8% 33.95260  -84.54993
## 609                   San Rafael                     5.0% 37.97353 -122.53109
## 610                    Royal Oak                    -1.7% 42.48948  -83.14465
## 611                  Des Plaines                     3.2% 42.03336  -87.88340
## 612              Huntington Park                    -4.1% 33.98168 -118.22507
## 613                      La Mesa                     6.9% 32.76783 -117.02308
## 614                  Orland Park                    13.9% 41.63031  -87.85394
## 615                       Auburn                    26.4% 32.60986  -85.48078
## 616                    Lakeville                    34.3% 44.64969  -93.24272
## 617                    Owensboro                     7.7% 37.77191  -87.11117
## 618                        Moore                    41.5% 35.33951  -97.48670
## 619                      Jupiter                    46.2% 26.93422  -80.09421
## 620                  Idaho Falls                    14.0% 43.49165 -112.03396
## 621                      Dubuque                     0.9% 42.50056  -90.66457
## 622                     Bartlett                    31.7% 35.20453  -89.87398
## 623                      Rowlett                    28.6% 32.90290  -96.56388
## 624                         Novi                    22.0% 42.48059  -83.47549
## 625                 White Plains                     8.5% 41.03399  -73.76291
## 626                      Arcadia                     8.3% 34.13973 -118.03534
## 627                      Redmond                    26.0% 47.67399 -122.12151
## 628                Lake Elsinore                    96.5% 33.66808 -117.32726
## 629                        Ocala                    20.8% 29.18720  -82.14009
## 630                  Tinley Park                    16.3% 41.57314  -87.79329
## 631                  Port Orange                    22.8% 29.13832  -80.99561
## 632                      Medford                     2.7% 42.41843  -71.10616
## 633                     Oak Lawn                     3.3% 41.71998  -87.74795
## 634                  Rocky Mount                    -3.1% 35.93821  -77.79053
## 635                       Kokomo                    21.3% 40.48643  -86.13360
## 636                Coconut Creek                    28.4% 26.25175  -80.17894
## 637                        Bowie                     8.6% 39.00678  -76.77914
## 638                       Berwyn                     5.1% 41.85059  -87.79367
## 639                 Midwest City                     4.5% 35.44951  -97.39670
## 640              Fountain Valley                     3.0% 33.70918 -117.95367
## 641                      Buckeye                   480.9% 33.37032 -112.58378
## 642             Dearborn Heights                    -3.0% 42.33698  -83.27326
## 643                     Woodland                    13.8% 38.67852 -121.77330
## 644                  Noblesville                    88.1% 40.04559  -86.00860
## 645                     Valdosta                    22.3% 30.83270  -83.27849
## 646                  Diamond Bar                     0.1% 34.02862 -117.81034
## 647                    Manhattan                    22.8% 39.18361  -96.57167
## 648                       Santee                     5.7% 32.83838 -116.97392
## 649                      Taunton                     0.0% 41.90010  -71.08977
## 650                      Sanford                    42.8% 28.80286  -81.26945
## 651                    Kettering                    -3.1% 39.68950  -84.16883
## 652                New Brunswick                    15.5% 40.48622  -74.45182
## 653                      Decatur                     3.1% 34.60593  -86.98334
## 654                     Chicopee                     1.7% 42.14870  -72.60787
## 655                     Anderson                    -6.6% 40.10532  -85.68025
## 656                      Margate                     2.7% 26.24453  -80.20644
## 657                Weymouth Town                          42.21807  -70.94104
## 658                    Hempstead                     4.0% 40.70621  -73.61874
## 659                    Corvallis                    11.8% 44.56457 -123.26204
## 660                     Eastvale                          33.95246 -117.58480
## 661                  Porterville                    20.1% 36.06523 -119.01677
## 662                   West Haven                     5.1% 41.27055  -72.94697
## 663                    Brentwood                   122.3% 37.93187 -121.69579
## 664                    Paramount                    -0.7% 33.88946 -118.15979
## 665                  Grand Forks                    11.5% 47.92526  -97.03285
## 666                   Georgetown                    91.9% 30.63326  -97.67798
## 667                   St. Peters                     6.5% 38.78747  -90.62989
## 668                    Shoreline                     2.9% 47.75565 -122.34152
## 669               Mount Prospect                    -2.5% 42.06642  -87.93729
## 670                      Hanford                    30.3% 36.32745 -119.64568
## 671                       Normal                    19.7% 40.51420  -88.99063
## 672                     Rosemead                     1.7% 34.08057 -118.07285
## 673                         Lehi                   176.3% 40.39162 -111.85077
## 674                    Pocatello                     5.4% 42.87130 -112.44553
## 675                     Highland                    21.0% 34.12834 -117.20865
## 676                       Novato                    13.3% 38.10742 -122.56970
## 677                  Port Arthur                    -6.0% 29.88495  -93.93995
## 678                  Carson City                     2.9% 39.16380 -119.76740
## 679                   San Marcos                    48.5% 29.88327  -97.94139
## 680               Hendersonville                    31.7% 36.30477  -86.62000
## 681                       Elyria                    -3.7% 41.36838  -82.10765
## 682                       Revere                    13.4% 42.40843  -71.01199
## 683                 Pflugerville                   123.4% 30.43937  -97.62000
## 684                    Greenwood                    46.0% 39.61366  -86.10665
## 685                     Bellevue                    20.5% 41.15436  -95.91456
## 686                      Wheaton                    -3.4% 41.86614  -88.10701
## 687                       Smyrna                    20.0% 33.88399  -84.51438
## 688                     Sarasota                     1.4% 27.33643  -82.53065
## 689                 Blue Springs                     9.9% 39.01695  -94.28161
## 690                       Colton                    10.8% 34.07390 -117.31365
## 691                       Euless                    15.1% 32.83707  -97.08195
## 692                  Castle Rock                   153.5% 39.37221 -104.85609
## 693               Cathedral City                    23.2% 33.78054 -116.46680
## 694                    Kingsport                    16.7% 36.54843  -82.56182
## 695             Lake Havasu City                    24.6% 34.48390 -114.32245
## 696                    Pensacola                    -6.0% 30.42131  -87.21691
## 697                      Hoboken                    35.8% 40.74399  -74.03236
## 698                      Yucaipa                    26.8% 34.03363 -117.04309
## 699                  Watsonville                    12.7% 36.91023 -121.75689
## 700                     Richland                    34.6% 46.28569 -119.28446
## 701                       Delano                    31.8% 35.76884 -119.24705
## 702              Hoffman Estates                     5.4% 42.06299  -88.12272
## 703                   Florissant                    -2.8% 38.78922  -90.32261
## 704                    Placentia                    11.8% 33.87224 -117.87034
## 705                West New York                    13.3% 40.78788  -74.01431
## 706                       Dublin                    70.0% 37.70215 -121.93579
## 707                     Oak Park                    -0.8% 41.88503  -87.78450
## 708                      Peabody                     7.5% 42.52787  -70.92866
## 709                  Perth Amboy                     9.7% 40.50677  -74.26542
## 710                 Battle Creek                    -2.8% 42.32115  -85.17971
## 711                    Bradenton                     3.4% 27.49893  -82.57482
## 712                       Gilroy                    23.9% 37.00578 -121.56828
## 713                      Milford                     1.8% 41.23070  -73.06404
## 714                       Albany                    25.5% 44.63651 -123.10593
## 715                       Ankeny                    86.9% 41.73179  -93.60013
## 716                    La Crosse                    -0.8% 43.80136  -91.23958
## 717                   Burlington                    12.1% 36.09569  -79.43780
## 718                       DeSoto                    36.0% 32.58970  -96.85707
## 719                 Harrisonburg                    27.1% 38.44957  -78.86892
## 720                   Minnetonka                     0.4% 44.92118  -93.46875
## 721                      Elkhart                    -2.5% 41.68199  -85.97667
## 722                     Lakewood                    -9.4% 41.48199  -81.79819
## 723                     Glendora                     3.1% 34.13612 -117.86534
## 724                    Southaven                    72.8% 34.98898  -90.01259
## 725                   Charleston                    -4.7% 38.34982  -81.63262
## 726                       Joplin                    11.2% 37.08423  -94.51328
## 727                         Enid                     8.1% 36.39559  -97.87839
## 728           Palm Beach Gardens                    39.6% 26.82339  -80.13865
## 729                   Brookhaven                          33.86510  -84.33659
## 730                   Plainfield                     5.7% 40.63371  -74.40737
## 731                 Grand Island                    16.0% 40.92640  -98.34201
## 732                  Palm Desert                    13.2% 33.72224 -116.37446
## 733                 Huntersville                    92.9% 35.41069  -80.84285
## 734                       Tigard                    17.8% 45.43123 -122.77149
## 735                       Lenexa                    24.6% 38.95362  -94.73357
## 736                      Saginaw                   -18.2% 43.41947  -83.95081
## 737                     Kentwood                    10.5% 42.86947  -85.64475
## 738                        Doral                   137.6% 25.81954  -80.35533
## 739                 Apple Valley                     9.2% 44.73191  -93.21772
## 740                    Grapevine                    17.6% 32.93429  -97.07807
## 741                  Aliso Viejo                    25.4% 33.56768 -117.72561
## 742                    Sammamish                    44.1% 47.61627 -122.03557
## 743                  Casa Grande                    86.0% 32.87950 -111.75735
## 744                Pinellas Park                     5.9% 27.84280  -82.69954
## 745                         Troy                     1.5% 42.72841  -73.69179
## 746              West Sacramento                    55.6% 38.58046 -121.53023
## 747                       Burien                    56.7% 47.47038 -122.34679
## 748                Commerce City                   135.4% 39.80832 -104.93387
## 749                       Monroe                    -6.1% 32.50931  -92.11930
## 750                     Cerritos                    -3.6% 33.85835 -118.06479
## 751                Downers Grove                     0.0% 41.80892  -88.01117
## 752                 Coral Gables                    16.1% 25.72149  -80.26838
## 753                       Wilson                    10.1% 35.72127  -77.91554
## 754                Niagara Falls                   -10.8% 43.09621  -79.03774
## 755                        Poway                     2.4% 32.96282 -117.03586
## 756                        Edina                     4.1% 44.88969  -93.34995
## 757               Cuyahoga Falls                    -0.2% 41.13394  -81.48456
## 758       Rancho Santa Margarita                     4.6% 33.64086 -117.60310
## 759                   Harrisburg                     0.6% 40.27319  -76.88670
## 760                   Huntington                    -5.0% 38.41925  -82.44515
## 761                    La Mirada                     4.6% 33.91724 -118.01201
## 762                      Cypress                     5.3% 33.81696 -118.03729
## 763                     Caldwell                    77.1% 43.66294 -116.68736
## 764                        Logan                    14.5% 41.73698 -111.83384
## 765                    Galveston                   -15.2% 29.30135  -94.79770
## 766                    Sheboygan                    -3.9% 43.75083  -87.71453
## 767                   Middletown                    -5.7% 39.51506  -84.39828
## 768                       Murray                     6.6% 40.66689 -111.88799
## 769                      Roswell                     7.5% 33.39427 -104.52302
## 770                       Parker                    96.4% 39.51860 -104.76136
## 771                      Bedford                     2.9% 32.84402  -97.14307
## 772                 East Lansing                     4.2% 42.73698  -84.48387
## 773                      Methuen                    10.3% 42.72620  -71.19089
## 774                       Covina                     3.3% 34.09001 -117.89034
## 775                   Alexandria                     4.1% 31.31129  -92.44514
## 776                      Olympia                    12.1% 47.03787 -122.90070
## 777                       Euclid                    -8.4% 41.59310  -81.52679
## 778                    Mishawaka                     2.0% 41.66199  -86.15862
## 779                       Salina                     4.5% 38.84028  -97.61142
## 780                        Azusa                     6.7% 34.13362 -117.90756
## 781                       Newark                     3.1% 40.05812  -82.40126
## 782                 Chesterfield                     1.9% 38.66311  -90.57707
## 783                     Leesburg                    66.0% 39.11566  -77.56360
## 784                     Dunwoody                          33.94621  -84.33465
## 785                  Hattiesburg                     3.1% 31.32712  -89.29034
## 786                    Roseville                    -1.0% 42.49726  -82.93714
## 787               Bonita Springs                    43.8% 26.33981  -81.77870
## 788                      Portage                     5.7% 42.20115  -85.58000
## 789               St. Louis Park                     7.3% 44.95974  -93.37022
## 790                 Collierville                    43.4% 35.04204  -89.66453
## 791                   Middletown                     3.6% 41.56232  -72.65065
## 792                   Stillwater                    20.1% 36.11561  -97.05837
## 793              East Providence                    -3.3% 41.81371  -71.37005
## 794                     Lawrence                    20.5% 39.83865  -86.02526
## 795                    Wauwatosa                     0.0% 43.04946  -88.00759
## 796                       Mentor                    -6.6% 41.66616  -81.33955
## 797                        Ceres                    34.0% 37.59493 -120.95771
## 798                   Cedar Hill                    42.4% 32.58847  -96.95612
## 799                    Mansfield                   -10.1% 40.75839  -82.51545
## 800                   Binghamton                    -1.7% 42.09869  -75.91797
## 801                Coeur d'Alene                    32.8% 47.67768 -116.78047
## 802              San Luis Obispo                     4.4% 35.28275 -120.65962
## 803                        Minot                    26.6% 48.23297 -101.29229
## 804                 Palm Springs                     7.7% 33.83030 -116.54529
## 805                   Pine Bluff                   -16.2% 34.22843  -92.00320
## 806                   Texas City                    10.3% 29.38385  -94.90270
## 807                  Summerville                    62.9% 33.01850  -80.17565
## 808                   Twin Falls                    31.5% 42.56297 -114.46087
## 809               Jeffersonville                    53.3% 38.27757  -85.73718
## 810                  San Jacinto                    91.8% 33.78391 -116.95864
## 811                      Madison                    53.7% 34.69926  -86.74833
## 812                      Altoona                    -7.3% 40.51868  -78.39474
## 813                     Columbus                    16.4% 39.20144  -85.92138
## 814                  Beavercreek                    19.0% 39.70923  -84.06327
## 815                       Apopka                    63.9% 28.69341  -81.53221
## 816                     Elmhurst                     5.7% 41.89947  -87.94034
## 817                     Maricopa                  2503.4% 33.05811 -112.04764
## 818                   Farmington                    18.1% 36.72806 -108.21869
## 819                     Glenview                     5.2% 42.06975  -87.78784
## 820            Cleveland Heights                   -10.3% 41.52005  -81.55624
## 821                       Draper                    77.4% 40.52467 -111.86382
## 822                      Lincoln                   285.2% 38.89156 -121.29301
## 823                 Sierra Vista                    19.3% 31.54550 -110.27729
## 824                        Lacey                    41.7% 47.03426 -122.82319
## 825                       Biloxi                   -11.5% 30.39603  -88.88531
## 826                 Strongsville                     1.9% 41.31450  -81.83569
## 827              Barnstable Town                    -7.1% 41.70032  -70.30020
## 828                        Wylie                   185.2% 33.01512  -96.53888
## 829                   Sayreville                     9.6% 40.45940  -74.36085
## 830                   Kannapolis                    18.6% 35.48736  -80.62173
## 831              Charlottesville                    10.5% 38.02931  -78.47668
## 832                    Littleton                     9.4% 39.61332 -105.01665
## 833                   Titusville                     7.8% 28.61222  -80.80755
## 834                   Hackensack                     2.9% 40.88593  -74.04347
## 835                       Newark                     3.3% 37.52966 -122.04024
## 836                   Pittsfield                    -3.6% 42.45008  -73.24538
## 837                         York                     6.4% 39.96260  -76.72774
## 838                      Lombard                     2.9% 41.88003  -88.00784
## 839                    Attleboro                     4.6% 41.94454  -71.28561
## 840                       DeKalb                    11.8% 41.92947  -88.75036
## 841                   Blacksburg                     9.4% 37.22957  -80.41394
## 842                       Dublin                    37.6% 40.09923  -83.11408
## 843                  Haltom City                    11.4% 32.79957  -97.26918
## 844                       Lompoc                     5.5% 34.63915 -120.45794
## 845                    El Centro                    13.7% 32.79200 -115.56305
## 846                     Danville                     3.7% 37.82159 -121.99996
## 847               Jefferson City                     6.7% 38.57670  -92.17352
## 848                   Cutler Bay                    42.9% 25.58083  -80.34686
## 849                 Oakland Park                     2.7% 26.17231  -80.13199
## 850            North Miami Beach                     3.6% 25.93315  -80.16255
## 851                     Freeport                    -1.4% 40.65760  -73.58318
## 852                       Moline                    -1.9% 41.50670  -90.51513
## 853                    Coachella                    88.4% 33.68030 -116.17389
## 854                  Fort Pierce                     6.9% 27.44671  -80.32561
## 855                       Smyrna                    54.9% 35.98284  -86.51860
## 856                    Bountiful                     3.9% 40.88939 -111.88077
## 857                  Fond du Lac                     1.7% 43.77304  -88.44705
## 858                      Everett                    12.1% 42.40843  -71.05366
## 859                     Danville                   -11.0% 36.58597  -79.39502
## 860                       Keller                    53.3% 32.93419  -97.22930
## 861                   Belleville                     1.2% 38.52005  -89.98399
## 862                 Bell Gardens                    -2.7% 33.96529 -118.15146
## 863                    Cleveland                    14.1% 35.15952  -84.87661
## 864             North Lauderdale                    10.8% 26.21730  -80.22588
## 865                    Fairfield                     1.2% 39.34547  -84.56032
## 866                        Salem                     5.1% 42.51954  -70.89672
## 867          Rancho Palos Verdes                     2.9% 33.74446 -118.38702
## 868                    San Bruno                     5.6% 37.63049 -122.41108
## 869                      Concord                     4.1% 43.20814  -71.53757
## 870                   Burlington                     6.1% 44.47588  -73.21207
## 871                         Apex                    98.8% 35.73265  -78.85029
## 872                      Midland                     0.9% 43.61558  -84.24721
## 873            Altamonte Springs                     2.0% 28.66111  -81.36562
## 874                   Hutchinson                     0.1% 38.06084  -97.92977
## 875                Buffalo Grove                    -3.4% 42.16628  -87.96313
## 876                    Urbandale                    41.5% 41.62666  -93.71217
## 877                State College                     8.7% 40.79339  -77.86000
## 878                       Urbana                    10.3% 40.11059  -88.20727
## 879                   Plainfield                   203.6% 41.63222  -88.21203
## 880                     Manassas                    19.5% 38.75095  -77.47527
## 881                     Bartlett                    13.1% 41.99503  -88.18563
## 882                       Kearny                     2.8% 40.76843  -74.14542
## 883                   Oro Valley                    27.0% 32.39091 -110.96649
## 884                      Findlay                     5.8% 41.04422  -83.64993
## 885                 Rohnert Park                     0.0% 38.33964 -122.70110
## 886                    Westfield                     3.0% 42.12509  -72.74954
## 887                       Linden                     4.7% 40.62205  -74.24459
## 888                       Sumter                     1.3% 33.92044  -80.34147
## 889                 Wilkes-Barre                    -4.3% 41.24591  -75.88131
## 890                   Woonsocket                    -5.2% 42.00288  -71.51478
## 891                   Leominster                    -1.1% 42.52509  -71.75979
## 892                      Shelton                     7.3% 41.31649  -73.09316
## 893                         Brea                    15.2% 33.91668 -117.90006
## 894                    Covington                    -4.7% 39.08367  -84.50855
## 895                     Rockwall                   117.2% 32.93123  -96.45971
## 896                     Meridian                    -0.9% 32.36431  -88.70366
## 897                     Riverton                    61.6% 40.52189 -111.93910
## 898                    St. Cloud                    86.2% 28.24890  -81.28118
## 899                       Quincy                     0.5% 39.93560  -91.40987
## 900                  Morgan Hill                    19.5% 37.13050 -121.65439
## 901                       Warren                   -15.2% 41.23756  -80.81842
## 902                      Edmonds                     2.9% 47.81065 -122.37736
## 903                     Burleson                    85.3% 32.54208  -97.32085
## 904                      Beverly                     2.0% 42.55843  -70.88005
## 905                      Mankato                    24.7% 44.16358  -93.99940
## 906                   Hagerstown                    10.4% 39.64176  -77.71999
## 907                     Prescott                    18.1% 34.54002 -112.46850
## 908                     Campbell                     4.2% 37.28717 -121.94996
## 909                  Cedar Falls                    12.0% 42.53490  -92.44532
## 910                     Beaumont                   254.5% 33.92946 -116.97725
## 911                    La Puente                    -1.6% 34.02001 -117.94951
## 912                 Crystal Lake                     5.3% 42.24113  -88.31620
## 913                    Fitchburg                     3.5% 42.58342  -71.80230
## 914                 Carol Stream                    -0.2% 41.91253  -88.13479
## 915                      Hickory                     7.0% 35.73445  -81.34446
## 916                   Streamwood                    10.1% 42.02558  -88.17841
## 917                      Norwich                    11.6% 41.52426  -72.07591
## 918                      Coppell                    10.3% 32.95457  -97.01501
## 919                  San Gabriel                     0.9% 34.09611 -118.10583
## 920                      Holyoke                     0.9% 42.20426  -72.61620
## 921                  Bentonville                    97.7% 36.37285  -94.20882
## 922                     Florence                    10.2% 34.79981  -87.67725
## 923            Peachtree Corners                          33.96989  -84.22146
## 924                    Brentwood                    51.9% 36.03312  -86.78278
## 925                      Bozeman                    41.9% 45.67700 -111.04293
## 926                   New Berlin                     3.6% 42.97640  -88.10842
## 927                  Goose Creek                    26.1% 32.98101  -80.03259
## 928                   Huntsville                    13.2% 30.72353  -95.55078
## 929              Prescott Valley                    62.9% 34.61002 -112.31572
## 930                    Maplewood                    12.3% 44.95302  -92.99522
## 931                   Romeoville                    79.5% 41.64753  -88.08951
## 932                  Duncanville                     9.7% 32.65180  -96.90834
## 933                Atlantic City                    -2.2% 39.36428  -74.42293
## 934                       Clovis                    21.3% 34.40480 -103.20523
## 935                   The Colony                    45.7% 33.08061  -96.89283
## 936                  Culver City                     1.3% 34.02112 -118.39647
## 937                  Marlborough                     7.6% 42.34593  -71.55229
## 938           Hilton Head Island                    16.0% 32.21632  -80.75261
## 939                     Moorhead                    21.3% 46.87376  -96.76780
## 940                     Calexico                    44.0% 32.67895 -115.49888
## 941                Bullhead City                    15.9% 35.13594 -114.52860
## 942                   Germantown                     4.1% 35.08676  -89.81009
## 943                    La Quinta                    59.9% 33.66336 -116.31001
## 944                    Lancaster                    10.7% 39.71368  -82.59933
## 945                       Wausau                     1.7% 44.95914  -89.63012
## 946                      Sherman                    11.6% 33.63566  -96.60888
## 947                        Ocoee                    57.9% 28.56917  -81.54396
## 948                     Shakopee                    85.7% 44.79740  -93.52729
## 949                       Woburn                     4.4% 42.47926  -71.15228
## 950                    Bremerton                     4.9% 47.56732 -122.63294
## 951                  Rock Island                    -1.9% 41.50948  -90.57875
## 952                     Muskogee                    -0.7% 35.74788  -95.36969
## 953               Cape Girardeau                     9.4% 37.30588  -89.51815
## 954                    Annapolis                     7.6% 38.97845  -76.49218
## 955                   Greenacres                    35.5% 26.62763  -80.13539
## 956                 Ormond Beach                     5.8% 29.28581  -81.05589
## 957             Hallandale Beach                    12.4% 25.98120  -80.14838
## 958                      Stanton                     2.8% 33.80252 -117.99312
## 959                     Puyallup                    11.8% 47.18538 -122.29290
## 960                     Pacifica                     0.5% 37.61383 -122.48692
## 961                 Hanover Park                     0.6% 41.99947  -88.14507
## 962                        Hurst                     5.8% 32.82346  -97.17057
## 963                         Lima                    -8.1% 40.74255  -84.10523
## 964                       Marana                   166.2% 32.43638 -111.22244
## 965              Carpentersville                    22.8% 42.12114  -88.25786
## 966                       Oakley                    47.7% 37.99742 -121.71245
## 967                Huber Heights                    -0.2% 39.84395  -84.12466
## 968                    Lancaster                    46.4% 32.59208  -96.75611
## 969                    Montclair                    12.1% 34.07751 -117.68978
## 970                     Wheeling                     4.8% 42.13919  -87.92896
## 971                   Brookfield                    -1.9% 43.06057  -88.10648
## 972                   Park Ridge                     0.1% 42.01114  -87.84062
## 973                     Florence                    19.8% 34.19543  -79.76256
## 974                          Roy                    13.3% 41.16161 -112.02633
## 975                Winter Garden                   142.5% 28.56528  -81.58618
## 976                      Chelsea                     7.3% 42.39176  -71.03283
## 977                Valley Stream                     3.6% 40.66427  -73.70846
## 978                  Spartanburg                    -6.2% 34.94957  -81.93205
## 979                  Lake Oswego                     5.3% 45.42067 -122.67065
## 980                  Friendswood                    28.6% 29.52940  -95.20104
## 981                  Westerville                     5.7% 40.12617  -82.92907
## 982                   Northglenn                    15.5% 39.89618 -104.98115
## 983                  Phenix City                    31.9% 32.47098  -85.00077
## 984                   Grove City                    35.6% 39.88145  -83.09296
## 985                    Texarkana                     7.4% 33.42513  -94.04769
## 986                      Addison                     2.6% 41.93170  -87.98896
## 987                        Dover                    16.0% 39.15817  -75.52437
## 988                 Lincoln Park                    -6.7% 42.25059  -83.17854
## 989                 Calumet City                    -4.5% 41.61559  -87.52949
## 990                     Muskegon                    -7.1% 43.23418  -86.24839
## 991                     Aventura                    47.2% 25.95648  -80.13921
## 992                     Martinez                     3.4% 38.01937 -122.13413
## 993                   Greenfield                     4.8% 42.96140  -88.01259
## 994              Apache Junction                    15.7% 33.41505 -111.54958
## 995                     Monrovia                     0.2% 34.14426 -118.00195
## 996                      Weslaco                    28.8% 26.15952  -97.99084
## 997                       Keizer                    14.4% 44.99012 -123.02621
## 998                 Spanish Fork                    78.1% 40.11496 -111.65492
## 999                       Beloit                     2.9% 42.50835  -89.03178
## 1000                 Panama City                     0.1% 30.15881  -85.66021
##      population rank                state
## 1       8405837    1             New York
## 2       3884307    2           California
## 3       2718782    3             Illinois
## 4       2195914    4                Texas
## 5       1553165    5         Pennsylvania
## 6       1513367    6              Arizona
## 7       1409019    7                Texas
## 8       1355896    8           California
## 9       1257676    9                Texas
## 10       998537   10           California
## 11       885400   11                Texas
## 12       843393   12              Indiana
## 13       842583   13              Florida
## 14       837442   14           California
## 15       822553   15                 Ohio
## 16       792862   16       North Carolina
## 17       792727   17                Texas
## 18       688701   18             Michigan
## 19       674433   19                Texas
## 20       653450   20            Tennessee
## 21       652405   21           Washington
## 22       649495   22             Colorado
## 23       646449   23 District of Columbia
## 24       645966   24        Massachusetts
## 25       634464   25            Tennessee
## 26       622104   26             Maryland
## 27       610613   27             Oklahoma
## 28       609893   28             Kentucky
## 29       609456   29               Oregon
## 30       603488   30               Nevada
## 31       599164   31            Wisconsin
## 32       556495   32           New Mexico
## 33       526116   33              Arizona
## 34       509924   34           California
## 35       479686   35           California
## 36       469428   36           California
## 37       467007   37             Missouri
## 38       457587   38              Arizona
## 39       448479   39             Virginia
## 40       447841   40              Georgia
## 41       439886   41             Colorado
## 42       434353   42             Nebraska
## 43       431746   43       North Carolina
## 44       417650   44              Florida
## 45       406253   45           California
## 46       400070   46            Minnesota
## 47       398121   47             Oklahoma
## 48       390113   48                 Ohio
## 49       386552   49               Kansas
## 50       379577   50                Texas
## 51       378715   51            Louisiana
## 52       363630   52           California
## 53       352957   53              Florida
## 54       347884   54               Hawaii
## 55       345803   55             Colorado
## 56       345012   56           California
## 57       334227   57           California
## 58       318416   58             Missouri
## 59       316619   59           California
## 60       316381   60                Texas
## 61       308428   61             Kentucky
## 62       305841   62         Pennsylvania
## 63       300950   63               Alaska
## 64       298118   64           California
## 65       297517   65                 Ohio
## 66       294873   66            Minnesota
## 67       282313   67                 Ohio
## 68       279639   68       North Carolina
## 69       278427   69           New Jersey
## 70       274409   70                Texas
## 71       270811   71               Nevada
## 72       268738   72             Nebraska
## 73       258959   73             New York
## 74       257342   74           New Jersey
## 75       256780   75           California
## 76       256496   76              Indiana
## 77       255483   77              Florida
## 78       249688   78              Florida
## 79       249146   79              Arizona
## 80       248142   80                Texas
## 81       246139   81             Virginia
## 82       245475   82       North Carolina
## 83       243344   83            Wisconsin
## 84       239538   84                Texas
## 85       236716   85           California
## 86       236441   86       North Carolina
## 87       234632   87              Arizona
## 88       234566   88                Texas
## 89       233394   89              Florida
## 90       233294   90               Nevada
## 91       230571   91             Virginia
## 92       229972   92              Arizona
## 93       229426   93            Louisiana
## 94       228653   94                Texas
## 95       226918   95              Arizona
## 96       226877   96               Nevada
## 97       224922   97           California
## 98       214237   98                Idaho
## 99       214114   99             Virginia
## 100      213708  100           California
## 101      212113  101              Alabama
## 102      210721  102           Washington
## 103      210358  103             New York
## 104      207510  104                 Iowa
## 105      204933  105           California
## 106      204408  106       North Carolina
## 107      203446  107           Washington
## 108      203007  108           California
## 109      203003  109           California
## 110      202824  110              Georgia
## 111      201332  111              Alabama
## 112      201175  112           California
## 113      200327  113            Louisiana
## 114      199963  114             Illinois
## 115      199766  115             New York
## 116      198100  116                 Ohio
## 117      197575  117           California
## 118      197357  118             Arkansas
## 119      197350  119              Georgia
## 120      196429  120                Texas
## 121      196021  121           California
## 122      194899  122              Alabama
## 123      192294  123             Michigan
## 124      191180  124                 Utah
## 125      186411  125              Florida
## 126      186254  126              Alabama
## 127      183372  127                Texas
## 128      183270  128            Tennessee
## 129      182544  129        Massachusetts
## 130      182020  130             Virginia
## 131      181860  131                Texas
## 132      181260  132               Kansas
## 133      179590  133           California
## 134      177994  134         Rhode Island
## 135      175140  135           California
## 136      173366  136            Tennessee
## 137      172794  137           California
## 138      172638  138          Mississippi
## 139      172389  139              Florida
## 140      171990  140           California
## 141      171386  141           California
## 142      171016  142              Florida
## 143      168228  143              Arizona
## 144      167500  144           California
## 145      167405  145           Washington
## 146      165831  146              Florida
## 147      164676  147         South Dakota
## 148      164122  148             Missouri
## 149      162592  149              Arizona
## 150      162329  150              Florida
## 151      161007  151           California
## 152      160614  152               Oregon
## 153      159523  153           California
## 154      159503  154           California
## 155      159190  155               Oregon
## 156      157161  156           California
## 157      155662  157           California
## 158      153703  158        Massachusetts
## 159      152735  159                Texas
## 160      152061  160             Colorado
## 161      151574  161           California
## 162      151348  162           California
## 163      151088  163       North Carolina
## 164      150251  164             Illinois
## 165      148892  165             Virginia
## 166      148738  166           California
## 167      148559  167                Texas
## 168      148483  168               Kansas
## 169      147806  169             Illinois
## 170      147559  170           California
## 171      147478  171           California
## 172      147216  172          Connecticut
## 173      147214  173             Colorado
## 174      146526  174              Florida
## 175      145948  175           New Jersey
## 176      144864  176             Illinois
## 177      144669  177             New York
## 178      143484  178                Texas
## 179      143355  179                 Ohio
## 180      142772  180              Georgia
## 181      142357  181            Tennessee
## 182      139969  182           California
## 183      139731  183           California
## 184      138981  184           California
## 185      137147  185                Texas
## 186      136791  186                Texas
## 187      136699  187             Virginia
## 188      136639  188                Texas
## 189      134873  189             Michigan
## 190      133992  190           Washington
## 191      133579  191                 Utah
## 192      133358  192       South Carolina
## 193      131885  193               Kansas
## 194      131224  194             Michigan
## 195      130660  195          Connecticut
## 196      130288  196              Florida
## 197      129030  197                Texas
## 198      128731  198           California
## 199      128429  199                 Iowa
## 200      127999  200       South Carolina
## 201      127763  201           California
## 202      127679  202               Kansas
## 203      127558  203           New Jersey
## 204      127488  204              Florida
## 205      127359  205             Colorado
## 206      127035  206           California
## 207      126700  207                Texas
## 208      126604  208              Florida
## 209      126456  209          Connecticut
## 210      126181  210           California
## 211      125880  211           California
## 212      125017  212          Connecticut
## 213      124435  213           Washington
## 214      124276  214            Louisiana
## 215      123933  215                Texas
## 216      123546  216              Arizona
## 217      123099  217                Texas
## 218      121096  218           California
## 219      120310  219              Indiana
## 220      120245  220           California
## 221      120099  221                Texas
## 222      119980  222              Georgia
## 223      118837  223           California
## 224      118577  224         Pennsylvania
## 225      118197  225             Oklahoma
## 226      117796  226                Texas
## 227      117240  227             Missouri
## 228      117044  228            Tennessee
## 229      117025  229             Michigan
## 230      117006  230             Illinois
## 231      116768  231           California
## 232      116513  232             Illinois
## 233      116288  233                 Utah
## 234      115708  234           California
## 235      115276  235             Missouri
## 236      113972  236             Michigan
## 237      113658  237         North Dakota
## 238      113242  238           California
## 239      112174  239           California
## 240      112067  240       North Carolina
## 241      111707  241             Colorado
## 242      111542  242           California
## 243      111378  243              Florida
## 244      110972  244           California
## 245      110945  245             Colorado
## 246      110742  246            Minnesota
## 247      110720  247                Texas
## 248      110378  248        New Hampshire
## 249      110145  249             Illinois
## 250      110077  250                 Utah
## 251      109821  251                Texas
## 252      109703  252              Florida
## 253      109676  253          Connecticut
## 254      109397  254               Oregon
## 255      109320  255           California
## 256      109059  256              Montana
## 257      108861  257        Massachusetts
## 258      108817  258           California
## 259      108249  259             Colorado
## 260      107741  260       North Carolina
## 261      107740  261           California
## 262      107571  262           California
## 263      107479  263           California
## 264      107289  264        Massachusetts
## 265      107100  265           California
## 266      106780  266           California
## 267      106589  267           California
## 268      106114  268             Colorado
## 269      105370  269           Washington
## 270      104898  270              Florida
## 271      104898  271                Texas
## 272      104779  272            Wisconsin
## 273      104739  273           California
## 274      104709  274           California
## 275      104475  275                Texas
## 276      104410  276              Florida
## 277      104054  277       South Carolina
## 278      103500  278             Oklahoma
## 279      103166  279             Colorado
## 280      102436  280              Florida
## 281      102216  281           California
## 282      102211  282           California
## 283      102157  283                 Iowa
## 284      101910  284           California
## 285      101324  285           New Mexico
## 286      101128  286           California
## 287      101074  287                Texas
## 288      100886  288              Indiana
## 289      100710  289              Florida
## 290      100671  290         Pennsylvania
## 291      100223  291                Texas
## 292      100065  292                Texas
## 293      100050  293                Texas
## 294       99889  294            Wisconsin
## 295       99770  295              Georgia
## 296       99769  296           California
## 297       99763  297             Michigan
## 298       98465  298             Virginia
## 299       98424  299             New York
## 300       98030  300           California
## 301       97877  301           California
## 302       97492  302                Texas
## 303       97368  303               Oregon
## 304       97151  304             Oklahoma
## 305       97003  305           Washington
## 306       96929  306           California
## 307       96830  307              Florida
## 308       96539  308             Colorado
## 309       96346  309           California
## 310       96205  310             Virginia
## 311       95884  311             Michigan
## 312       95677  312           California
## 313       95334  313              Alabama
## 314       95208  314             Michigan
## 315       95078  315        Massachusetts
## 316       94275  316           California
## 317       94089  317        Massachusetts
## 318       94034  318              Georgia
## 319       93542  319               Oregon
## 320       93494  320        Massachusetts
## 321       93282  321               Nevada
## 322       93257  322           Washington
## 323       93184  323             Missouri
## 324       92734  324           Washington
## 325       92599  325           California
## 326       92472  326           California
## 327       92147  327           California
## 328       92020  328                Texas
## 329       91956  329           New Mexico
## 330       91923  330              Arizona
## 331       91739  331           California
## 332       91648  332                 Utah
## 333       91589  333        Massachusetts
## 334       91119  334           California
## 335       91113  335           Washington
## 336       91026  336              Florida
## 337       90983  337                Texas
## 338       90811  338               Kansas
## 339       90412  339           California
## 340       90268  340              Florida
## 341       90231  341                 Utah
## 342       90116  342              Florida
## 343       89981  343              Georgia
## 344       89919  344             Colorado
## 345       89407  345              Florida
## 346       89387  346           California
## 347       89130  347       North Carolina
## 348       88826  348             Illinois
## 349       88697  349        Massachusetts
## 350       88077  350           California
## 351       87971  351        Massachusetts
## 352       87965  352           California
## 353       87893  353         Pennsylvania
## 354       87776  354          Connecticut
## 355       87650  355             Arkansas
## 356       87273  356           California
## 357       87236  357       North Carolina
## 358       87137  358        New Hampshire
## 359       87004  359             Oklahoma
## 360       86635  360           California
## 361       86518  361                Idaho
## 362       86319  362            Minnesota
## 363       86290  363              Florida
## 364       86199  364           California
## 365       86128  365            Minnesota
## 366       85927  366              Indiana
## 367       85728  367             Virginia
## 368       85390  368           New Jersey
## 369       85285  369           California
## 370       85156  370           California
## 371       84691  371           California
## 372       84577  372           California
## 373       84430  373           Washington
## 374       84349  374           New Jersey
## 375       84249  375                 Utah
## 376       84126  376              Alabama
## 377       84103  377             Illinois
## 378       83891  378              Indiana
## 379       83860  379                Texas
## 380       83684  380          Connecticut
## 381       83596  381                Idaho
## 382       83539  382           California
## 383       83506  383       North Carolina
## 384       83447  384           California
## 385       83424  385             Illinois
## 386       82882  386           California
## 387       82821  387             Michigan
## 388       82809  388             Missouri
## 389       82788  389              Georgia
## 390       82631  390           Washington
## 391       82578  391             Michigan
## 392       82575  392              Indiana
## 393       82459  393                 Iowa
## 394       81971  394         Rhode Island
## 395       81750  395           California
## 396       81443  396                Texas
## 397       81295  397             Michigan
## 398       81236  398               Oregon
## 399       81121  399           California
## 400       81102  400           California
## 401       81050  401                Texas
## 402       80988  402           California
## 403       80872  403           California
## 404       80836  404                Texas
## 405       80566  405         Rhode Island
## 406       80429  406                 Ohio
## 407       79446  407             New York
## 408       79312  408           California
## 409       79068  409           California
## 410       78967  410              Indiana
## 411       78960  411             Arkansas
## 412       78902  412             Illinois
## 413       78822  413              Arizona
## 414       78804  414        Massachusetts
## 415       78740  415              Florida
## 416       78709  416                Texas
## 417       78450  417              Indiana
## 418       78409  418              Florida
## 419       78373  419            Minnesota
## 420       78327  420           California
## 421       78199  421            Wisconsin
## 422       78041  422              Florida
## 423       78014  423             Virginia
## 424       77846  424           California
## 425       77677  425               Oregon
## 426       77657  426        Massachusetts
## 427       77593  427           California
## 428       77508  428              Florida
## 429       77147  429             Missouri
## 430       76903  430           New Jersey
## 431       76817  431                 Utah
## 432       76762  432           Washington
## 433       76635  433           California
## 434       76572  434           California
## 435       76419  435           California
## 436       76185  436              Georgia
## 437       75994  437             Illinois
## 438       75806  438         Pennsylvania
## 439       75570  439             Illinois
## 440       75548  440             Michigan
## 441       75418  441                Texas
## 442       75413  442           California
## 443       75229  443             Arkansas
## 444       75018  444         Pennsylvania
## 445       74907  445             Illinois
## 446       74885  446       South Carolina
## 447       74860  447           Washington
## 448       74710  448             Illinois
## 449       74513  449           California
## 450       74110  450           California
## 451       74100  451             Michigan
## 452       74024  452            Louisiana
## 453       73987  453            Minnesota
## 454       73936  454             Illinois
## 455       73790  455                Texas
## 456       73596  456            Wisconsin
## 457       73209  457       North Carolina
## 458       73098  458           California
## 459       73006  459             Michigan
## 460       72952  460             Michigan
## 461       72939  461          Connecticut
## 462       72864  462              Arizona
## 463       72535  463                 Ohio
## 464       72531  464              Georgia
## 465       72528  465           California
## 466       72326  466           California
## 467       71948  467           California
## 468       71591  468                 Iowa
## 469       71551  469             Arkansas
## 470       71525  470             Delaware
## 471       71371  471           California
## 472       71334  472             Colorado
## 473       71172  473         Rhode Island
## 474       71097  474              Florida
## 475       71016  475            Wisconsin
## 476       71012  476          Mississippi
## 477       70924  477           California
## 478       70868  478           New Jersey
## 479       70812  479         South Dakota
## 480       70790  480                 Utah
## 481       70373  481              Indiana
## 482       70365  482           California
## 483       70316  483              Indiana
## 484       70190  484                Texas
## 485       70185  485                Texas
## 486       69999  486           California
## 487       69976  487           New Mexico
## 488       69813  488              Florida
## 489       69783  489           California
## 490       69350  490             Illinois
## 491       69122  491              Montana
## 492       69103  492       South Carolina
## 493       69079  493       North Carolina
## 494       68886  494            Tennessee
## 495       68667  495              Arizona
## 496       68609  496                Texas
## 497       68388  497              Florida
## 498       68366  498                 Iowa
## 499       68247  499           New Jersey
## 500       68224  500             New York
## 501       68190  501              Florida
## 502       68001  502              Alabama
## 503       67911  503           California
## 504       67815  504           California
## 505       67685  505            Tennessee
## 506       67599  506           Washington
## 507       67569  507             Missouri
## 508       67545  508            Wisconsin
## 509       67317  509                Texas
## 510       67034  510         North Dakota
## 511       67032  511           California
## 512       66975  512            Louisiana
## 513       66900  513           California
## 514       66893  514             Maryland
## 515       66778  515            Wisconsin
## 516       66695  516           California
## 517       66642  517           California
## 518       66333  518            Louisiana
## 519       66318  519                Maine
## 520       66297  520            Minnesota
## 521       66205  521           California
## 522       66174  522           California
## 523       66086  523           California
## 524       66075  524             Arkansas
## 525       65902  525             New York
## 526       65690  526             Maryland
## 527       65665  527                Texas
## 528       65656  528            Minnesota
## 529       65453  529            Minnesota
## 530       65416  530           California
## 531       65415  531            Minnesota
## 532       65184  532                 Ohio
## 533       65176  533             Illinois
## 534       65173  534              Florida
## 535       65123  535            Tennessee
## 536       65098  536                Texas
## 537       65040  537           California
## 538       65028  538           New Jersey
## 539       64652  539           California
## 540       64544  540           New Jersey
## 541       64323  541               Kansas
## 542       64079  542              Florida
## 543       64072  544             Maryland
## 544       64072  543              Florida
## 545       63820  545            Wisconsin
## 546       63816  546             Arkansas
## 547       63771  547           California
## 548       63710  548                 Ohio
## 549       63495  549           California
## 550       63338  550           California
## 551       63279  551                Texas
## 552       63269  552           Washington
## 553       63155  553              Florida
## 554       63105  554           California
## 555       63032  555                Texas
## 556       62864  556           California
## 557       62603  557            Minnesota
## 558       62448  558              Wyoming
## 559       62316  559              Florida
## 560       62298  560              Georgia
## 561       62258  561                 Ohio
## 562       62227  562        Massachusetts
## 563       62103  563            Minnesota
## 564       62088  564        Massachusetts
## 565       61969  565                 Iowa
## 566       61817  566             Michigan
## 567       61808  567             New York
## 568       61792  568                 Iowa
## 569       61653  569           California
## 570       61588  570           California
## 571       61488  571             Kentucky
## 572       61434  572            Minnesota
## 573       61397  573       South Carolina
## 574       61255  574                 Iowa
## 575       61238  575                Texas
## 576       61170  576           California
## 577       61085  577           California
## 578       61050  578           New Jersey
## 579       61025  579              Indiana
## 580       61007  580              Florida
## 581       60872  581                Texas
## 582       60697  582            Wisconsin
## 583       60568  583          Connecticut
## 584       60519  584                 Utah
## 585       60509  585        Massachusetts
## 586       60456  586          Connecticut
## 587       60407  587            Minnesota
## 588       60202  588              Florida
## 589       60189  589           California
## 590       60177  590               Oregon
## 591       60112  591             Arkansas
## 592       60070  592             Michigan
## 593       59957  593           California
## 594       59887  594             Michigan
## 595       59834  595           California
## 596       59778  596             Colorado
## 597       59738  597           California
## 598       59635  598       North Carolina
## 599       59628  599              Wyoming
## 600       59471  600             Colorado
## 601       59440  601           California
## 602       59366  602                 Utah
## 603       59357  603                 Ohio
## 604       59351  604              Montana
## 605       59325  605         Pennsylvania
## 606       59212  606              Florida
## 607       59097  607           Washington
## 608       59089  608              Georgia
## 609       58994  609           California
## 610       58946  610             Michigan
## 611       58918  611             Illinois
## 612       58879  612           California
## 613       58642  613           California
## 614       58590  614             Illinois
## 615       58582  615              Alabama
## 616       58562  616            Minnesota
## 617       58416  617             Kentucky
## 618       58414  618             Oklahoma
## 619       58298  619              Florida
## 620       58292  620                Idaho
## 621       58253  621                 Iowa
## 622       58226  622            Tennessee
## 623       58043  623                Texas
## 624       57960  624             Michigan
## 625       57866  625             New York
## 626       57639  626           California
## 627       57530  627           Washington
## 628       57525  628           California
## 629       57468  629              Florida
## 630       57282  630             Illinois
## 631       57203  631              Florida
## 632       57170  632        Massachusetts
## 633       57073  633             Illinois
## 634       56954  634       North Carolina
## 635       56895  635              Indiana
## 636       56792  636              Florida
## 637       56759  637             Maryland
## 638       56758  638             Illinois
## 639       56756  639             Oklahoma
## 640       56707  640           California
## 641       56683  641              Arizona
## 642       56620  642             Michigan
## 643       56590  643           California
## 644       56540  644              Indiana
## 645       56481  645              Georgia
## 646       56449  646           California
## 647       56143  647               Kansas
## 648       56105  648           California
## 649       56069  649        Massachusetts
## 650       56002  650              Florida
## 651       55870  651                 Ohio
## 652       55831  652           New Jersey
## 653       55816  653              Alabama
## 654       55717  654        Massachusetts
## 655       55670  655              Indiana
## 656       55456  656              Florida
## 657       55419  657        Massachusetts
## 658       55361  658             New York
## 659       55298  659               Oregon
## 660       55191  660           California
## 661       55174  661           California
## 662       55046  662          Connecticut
## 663       55000  663           California
## 664       54980  664           California
## 665       54932  665         North Dakota
## 666       54898  666                Texas
## 667       54842  667             Missouri
## 668       54790  668           Washington
## 669       54771  669             Illinois
## 670       54686  670           California
## 671       54664  671             Illinois
## 672       54561  672           California
## 673       54382  673                 Utah
## 674       54350  674                Idaho
## 675       54291  675           California
## 676       54194  676           California
## 677       54135  677                Texas
## 678       54080  678               Nevada
## 679       54076  679                Texas
## 680       54068  680            Tennessee
## 681       53956  681                 Ohio
## 682       53756  682        Massachusetts
## 683       53752  683                Texas
## 684       53665  684              Indiana
## 685       53663  685             Nebraska
## 686       53648  686             Illinois
## 687       53438  687              Georgia
## 688       53326  688              Florida
## 689       53294  689             Missouri
## 690       53243  690           California
## 691       53224  691                Texas
## 692       53063  692             Colorado
## 693       52977  693           California
## 694       52962  694            Tennessee
## 695       52844  695              Arizona
## 696       52703  696              Florida
## 697       52575  697           New Jersey
## 698       52536  698           California
## 699       52477  699           California
## 700       52413  700           Washington
## 701       52403  701           California
## 702       52398  702             Illinois
## 703       52363  703             Missouri
## 704       52206  704           California
## 705       52122  705           New Jersey
## 706       52105  706           California
## 707       52066  707             Illinois
## 708       52044  708        Massachusetts
## 709       51982  709           New Jersey
## 710       51848  710             Michigan
## 711       51763  711              Florida
## 712       51701  712           California
## 713       51644  713          Connecticut
## 714       51583  714               Oregon
## 715       51567  715                 Iowa
## 716       51522  716            Wisconsin
## 717       51510  717       North Carolina
## 718       51483  718                Texas
## 719       51395  719             Virginia
## 720       51368  720            Minnesota
## 721       51265  721              Indiana
## 722       51143  722                 Ohio
## 723       51074  723           California
## 724       50997  724          Mississippi
## 725       50821  725        West Virginia
## 726       50789  726             Missouri
## 727       50725  727             Oklahoma
## 728       50699  728              Florida
## 729       50603  729              Georgia
## 730       50588  730           New Jersey
## 731       50550  731             Nebraska
## 732       50508  732           California
## 733       50458  733       North Carolina
## 734       50444  734               Oregon
## 735       50344  735               Kansas
## 736       50303  736             Michigan
## 737       50233  737             Michigan
## 738       50213  738              Florida
## 739       50201  739            Minnesota
## 740       50195  740                Texas
## 741       50175  741           California
## 742       50169  742           Washington
## 743       50111  743              Arizona
## 744       49998  744              Florida
## 745       49974  745             New York
## 746       49891  746           California
## 747       49858  747           Washington
## 748       49799  748             Colorado
## 749       49761  749            Louisiana
## 750       49707  750           California
## 751       49670  751             Illinois
## 752       49631  752              Florida
## 753       49628  753       North Carolina
## 754       49468  754             New York
## 755       49417  755           California
## 756       49376  756            Minnesota
## 757       49267  757                 Ohio
## 758       49228  758           California
## 759       49188  759         Pennsylvania
## 760       49177  760        West Virginia
## 761       49133  761           California
## 762       49087  762           California
## 763       48957  763                Idaho
## 764       48913  764                 Utah
## 765       48733  765                Texas
## 766       48725  766            Wisconsin
## 767       48630  767                 Ohio
## 768       48612  768                 Utah
## 769       48611  769           New Mexico
## 770       48608  770             Colorado
## 771       48592  771                Texas
## 772       48554  772             Michigan
## 773       48514  773        Massachusetts
## 774       48508  774           California
## 775       48426  775            Louisiana
## 776       48338  776           Washington
## 777       48139  777                 Ohio
## 778       47989  778              Indiana
## 779       47846  779               Kansas
## 780       47842  780           California
## 781       47777  781                 Ohio
## 782       47749  782             Missouri
## 783       47673  783             Virginia
## 784       47591  784              Georgia
## 785       47556  785          Mississippi
## 786       47555  786             Michigan
## 787       47547  787              Florida
## 788       47523  788             Michigan
## 789       47411  789            Minnesota
## 790       47333  790            Tennessee
## 791       47333  791          Connecticut
## 792       47186  792             Oklahoma
## 793       47149  793         Rhode Island
## 794       47135  794              Indiana
## 795       47134  795            Wisconsin
## 796       46979  796                 Ohio
## 797       46714  797           California
## 798       46663  798                Texas
## 799       46454  799                 Ohio
## 800       46444  800             New York
## 801       46402  801                Idaho
## 802       46377  802           California
## 803       46321  803         North Dakota
## 804       46281  804           California
## 805       46094  805             Arkansas
## 806       46081  806                Texas
## 807       46074  807       South Carolina
## 808       45981  808                Idaho
## 809       45929  809              Indiana
## 810       45851  810           California
## 811       45799  811              Alabama
## 812       45796  812         Pennsylvania
## 813       45775  813              Indiana
## 814       45712  814                 Ohio
## 815       45587  815              Florida
## 816       45556  816             Illinois
## 817       45508  817              Arizona
## 818       45426  818           New Mexico
## 819       45417  819             Illinois
## 820       45394  820                 Ohio
## 821       45285  821                 Utah
## 822       45237  822           California
## 823       45129  823              Arizona
## 824       44919  824           Washington
## 825       44820  825          Mississippi
## 826       44730  826                 Ohio
## 827       44641  827        Massachusetts
## 828       44575  828                Texas
## 829       44412  829           New Jersey
## 830       44359  830       North Carolina
## 831       44349  831             Virginia
## 832       44275  832             Colorado
## 833       44206  833              Florida
## 834       44113  834           New Jersey
## 835       44096  835           California
## 836       44057  836        Massachusetts
## 837       43935  837         Pennsylvania
## 838       43907  838             Illinois
## 839       43886  839        Massachusetts
## 840       43849  840             Illinois
## 841       43609  841             Virginia
## 842       43607  842                 Ohio
## 843       43580  843                Texas
## 844       43509  844           California
## 845       43363  845           California
## 846       43341  846           California
## 847       43330  847             Missouri
## 848       43328  848              Florida
## 849       43286  849              Florida
## 850       43250  850              Florida
## 851       43167  851             New York
## 852       43116  852             Illinois
## 853       43092  853           California
## 854       43074  854              Florida
## 855       43060  855            Tennessee
## 856       43023  856                 Utah
## 857       42970  857            Wisconsin
## 858       42935  858        Massachusetts
## 859       42907  859             Virginia
## 860       42907  860                Texas
## 861       42895  861             Illinois
## 862       42889  862           California
## 863       42774  863            Tennessee
## 864       42757  864              Florida
## 865       42635  865                 Ohio
## 866       42544  866        Massachusetts
## 867       42448  867           California
## 868       42443  868           California
## 869       42419  869        New Hampshire
## 870       42284  870              Vermont
## 871       42214  871       North Carolina
## 872       42181  872             Michigan
## 873       42150  873              Florida
## 874       41889  874               Kansas
## 875       41778  875             Illinois
## 876       41776  876                 Iowa
## 877       41757  877         Pennsylvania
## 878       41752  878             Illinois
## 879       41734  879             Illinois
## 880       41705  880             Virginia
## 881       41679  881             Illinois
## 882       41664  882           New Jersey
## 883       41627  883              Arizona
## 884       41512  884                 Ohio
## 885       41398  885           California
## 886       41301  887        Massachusetts
## 887       41301  886           New Jersey
## 888       41190  888       South Carolina
## 889       41108  889         Pennsylvania
## 890       41026  890         Rhode Island
## 891       41002  891        Massachusetts
## 892       40999  892          Connecticut
## 893       40963  893           California
## 894       40956  894             Kentucky
## 895       40922  895                Texas
## 896       40921  896          Mississippi
## 897       40921  897                 Utah
## 898       40918  898              Florida
## 899       40915  899             Illinois
## 900       40836  900           California
## 901       40768  901                 Ohio
## 902       40727  902           Washington
## 903       40714  903                Texas
## 904       40664  904        Massachusetts
## 905       40641  905            Minnesota
## 906       40612  906             Maryland
## 907       40590  907              Arizona
## 908       40584  908           California
## 909       40566  909                 Iowa
## 910       40481  910           California
## 911       40435  911           California
## 912       40388  912             Illinois
## 913       40383  913        Massachusetts
## 914       40379  914             Illinois
## 915       40361  915       North Carolina
## 916       40351  916             Illinois
## 917       40347  917          Connecticut
## 918       40342  918                Texas
## 919       40275  919           California
## 920       40249  920        Massachusetts
## 921       40167  921             Arkansas
## 922       40059  922              Alabama
## 923       40059  923              Georgia
## 924       40021  924            Tennessee
## 925       39860  925              Montana
## 926       39834  926            Wisconsin
## 927       39823  927       South Carolina
## 928       39795  928                Texas
## 929       39791  929              Arizona
## 930       39765  930            Minnesota
## 931       39650  931             Illinois
## 932       39605  932                Texas
## 933       39551  933           New Jersey
## 934       39508  934           New Mexico
## 935       39458  935                Texas
## 936       39428  936           California
## 937       39414  937        Massachusetts
## 938       39412  938       South Carolina
## 939       39398  939            Minnesota
## 940       39389  940           California
## 941       39383  941              Arizona
## 942       39375  942            Tennessee
## 943       39331  943           California
## 944       39325  944                 Ohio
## 945       39309  945            Wisconsin
## 946       39296  946                Texas
## 947       39172  947              Florida
## 948       39167  948            Minnesota
## 949       39083  949        Massachusetts
## 950       39056  950           Washington
## 951       38877  951             Illinois
## 952       38863  952             Oklahoma
## 953       38816  953             Missouri
## 954       38722  954             Maryland
## 955       38696  955              Florida
## 956       38661  956              Florida
## 957       38632  957              Florida
## 958       38623  958           California
## 959       38609  959           Washington
## 960       38606  960           California
## 961       38510  961             Illinois
## 962       38448  962                Texas
## 963       38355  963                 Ohio
## 964       38290  964              Arizona
## 965       38241  965             Illinois
## 966       38194  966           California
## 967       38142  967                 Ohio
## 968       38071  968                Texas
## 969       38027  969           California
## 970       38015  970             Illinois
## 971       37999  971            Wisconsin
## 972       37839  972             Illinois
## 973       37792  973       South Carolina
## 974       37733  974                 Utah
## 975       37711  975              Florida
## 976       37670  976        Massachusetts
## 977       37659  977             New York
## 978       37647  978       South Carolina
## 979       37610  979               Oregon
## 980       37587  980                Texas
## 981       37530  981                 Ohio
## 982       37499  982             Colorado
## 983       37498  983              Alabama
## 984       37490  984                 Ohio
## 985       37442  985                Texas
## 986       37385  986             Illinois
## 987       37366  987             Delaware
## 988       37313  988             Michigan
## 989       37240  989             Illinois
## 990       37213  990             Michigan
## 991       37199  991              Florida
## 992       37165  992           California
## 993       37159  993            Wisconsin
## 994       37130  994              Arizona
## 995       37101  995           California
## 996       37093  996                Texas
## 997       37064  997               Oregon
## 998       36956  998                 Utah
## 999       36888  999            Wisconsin
## 1000      36877 1000              Florida
#This dataframe shows data on cities that experienced population growth from 2000 - 2013. The dataframe contains the city, state, lat and long as well as population and rank
  1. Calculate the average population in the dataframe. Why is using mean() directly not working? Find a way to correct the data type of this variable so you can calculate the average (and then calculate the average)

Hint: use str(pop) or glimpse(pop) to help understand the dataframe

pop$population <-as.numeric(pop$population)
mean(pop$population)
## [1] 131132.4
 #The mean is  131132.4
  1. What is the population of the smallest city in the dataframe? Which state is it in?
pop[which.min(pop$population),]
##             city growth_from_2000_to_2013 latitude longitude population rank
## 1000 Panama City                     0.1% 30.15881 -85.66021      36877 1000
##        state
## 1000 Florida
#Population is 36877 and is for Panama City

Step 2: Merge the population data with the state name data

  1. Read in the state name .csv file from the URL below into a dataframe named abbr (for “abbreviation”) – make sure to use the read_csv() function from the tidyverse package:
    https://intro-datascience.s3.us-east-2.amazonaws.com/statesInfo.csv
abbr<- read_csv(url("https://intro-datascience.s3.us-east-2.amazonaws.com/statesInfo.csv"))
## Rows: 51 Columns: 2
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (2): State, Abbreviation
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
abbr
## # A tibble: 51 × 2
##    State                Abbreviation
##    <chr>                <chr>       
##  1 Alabama              AL          
##  2 Alaska               AK          
##  3 Arizona              AZ          
##  4 Arkansas             AR          
##  5 California           CA          
##  6 Colorado             CO          
##  7 Connecticut          CT          
##  8 Delaware             DE          
##  9 District of Columbia DC          
## 10 Florida              FL          
## # … with 41 more rows
  1. To successfully merge the dataframe pop with the abbr dataframe, we need to identify a column they have in common which will serve as the “key” to merge on. One column both dataframes have is the state column. The only problem is the slight column name discrepancy – in pop, the column is called “state” and in abbr“State.” These names need to be reconciled for the merge() function to work. Find a way to rename abbr’s “State” to match the state column in pop.
abbr <- abbr %>%
  rename(state=State)

abbr
## # A tibble: 51 × 2
##    state                Abbreviation
##    <chr>                <chr>       
##  1 Alabama              AL          
##  2 Alaska               AK          
##  3 Arizona              AZ          
##  4 Arkansas             AR          
##  5 California           CA          
##  6 Colorado             CO          
##  7 Connecticut          CT          
##  8 Delaware             DE          
##  9 District of Columbia DC          
## 10 Florida              FL          
## # … with 41 more rows
  1. Merge the two dataframes (using the ‘state’ column from both dataframes), storing the resulting dataframe in dfNew.
dfNew <- merge(abbr, pop, by= 'state')
dfNew 
##                     state Abbreviation                        city
## 1                 Alabama           AL                      Mobile
## 2                 Alabama           AL                 Phenix City
## 3                 Alabama           AL                  Montgomery
## 4                 Alabama           AL                     Decatur
## 5                 Alabama           AL                  Huntsville
## 6                 Alabama           AL                     Madison
## 7                 Alabama           AL                  Tuscaloosa
## 8                 Alabama           AL                    Florence
## 9                 Alabama           AL                      Auburn
## 10                Alabama           AL                      Hoover
## 11                Alabama           AL                      Dothan
## 12                Alabama           AL                  Birmingham
## 13                 Alaska           AK                   Anchorage
## 14                Arizona           AZ                 Casa Grande
## 15                Arizona           AZ                     Gilbert
## 16                Arizona           AZ                    Surprise
## 17                Arizona           AZ                  Scottsdale
## 18                Arizona           AZ               Bullhead City
## 19                Arizona           AZ                    Glendale
## 20                Arizona           AZ                    Prescott
## 21                Arizona           AZ                        Mesa
## 22                Arizona           AZ                       Tempe
## 23                Arizona           AZ                   Flagstaff
## 24                Arizona           AZ                      Marana
## 25                Arizona           AZ                      Tucson
## 26                Arizona           AZ             Apache Junction
## 27                Arizona           AZ             Prescott Valley
## 28                Arizona           AZ                      Peoria
## 29                Arizona           AZ                    Avondale
## 30                Arizona           AZ                    Maricopa
## 31                Arizona           AZ                        Yuma
## 32                Arizona           AZ                     Phoenix
## 33                Arizona           AZ                    Goodyear
## 34                Arizona           AZ                    Chandler
## 35                Arizona           AZ                     Buckeye
## 36                Arizona           AZ                  Oro Valley
## 37                Arizona           AZ                Sierra Vista
## 38                Arizona           AZ            Lake Havasu City
## 39               Arkansas           AR                 Bentonville
## 40               Arkansas           AR                  Pine Bluff
## 41               Arkansas           AR                  Springdale
## 42               Arkansas           AR                      Rogers
## 43               Arkansas           AR                      Conway
## 44               Arkansas           AR                  Fort Smith
## 45               Arkansas           AR           North Little Rock
## 46               Arkansas           AR                   Jonesboro
## 47               Arkansas           AR                Fayetteville
## 48               Arkansas           AR                 Little Rock
## 49             California           CA                   Elk Grove
## 50             California           CA                      Santee
## 51             California           CA                        Napa
## 52             California           CA                    Temecula
## 53             California           CA                      Carson
## 54             California           CA                  San Rafael
## 55             California           CA                      Pomona
## 56             California           CA                Walnut Creek
## 57             California           CA                   San Mateo
## 58             California           CA                   Lancaster
## 59             California           CA                  Santa Rosa
## 60             California           CA                   Oceanside
## 61             California           CA                    Murrieta
## 62             California           CA                    Alhambra
## 63             California           CA                     Ontario
## 64             California           CA                   Livermore
## 65             California           CA               Santa Clarita
## 66             California           CA                San Clemente
## 67             California           CA               San Francisco
## 68             California           CA                 Los Angeles
## 69             California           CA                     Fontana
## 70             California           CA                  South Gate
## 71             California           CA               Jurupa Valley
## 72             California           CA                     Alameda
## 73             California           CA            Rancho Cucamonga
## 74             California           CA                      Fresno
## 75             California           CA                  Sacramento
## 76             California           CA             San Luis Obispo
## 77             California           CA                     Norwalk
## 78             California           CA                  Montebello
## 79             California           CA                 Santa Maria
## 80             California           CA                 Yorba Linda
## 81             California           CA                      Oxnard
## 82             California           CA                      Rialto
## 83             California           CA                    Carlsbad
## 84             California           CA                Santa Monica
## 85             California           CA                     Oakland
## 86             California           CA                   San Ramon
## 87             California           CA              Citrus Heights
## 88             California           CA                   San Diego
## 89             California           CA                   Sunnyvale
## 90             California           CA                    Stockton
## 91             California           CA                    San Jose
## 92             California           CA                 Bakersfield
## 93             California           CA               Monterey Park
## 94             California           CA                    Glendale
## 95             California           CA               Laguna Niguel
## 96             California           CA                     Anaheim
## 97             California           CA                   Santa Ana
## 98             California           CA                      Tustin
## 99             California           CA                   Riverside
## 100            California           CA              San Bernardino
## 101            California           CA                      Orange
## 102            California           CA                     Vallejo
## 103            California           CA                      Perris
## 104            California           CA                  San Marcos
## 105            California           CA                     Modesto
## 106            California           CA                        Lodi
## 107            California           CA                      Clovis
## 108            California           CA                    Monrovia
## 109            California           CA                       Chico
## 110            California           CA                    Berkeley
## 111            California           CA                   Daly City
## 112            California           CA               Moreno Valley
## 113            California           CA                     Burbank
## 114            California           CA               Newport Beach
## 115            California           CA                   Vacaville
## 116            California           CA                    Palmdale
## 117            California           CA                      Merced
## 118            California           CA                Palm Springs
## 119            California           CA                     Turlock
## 120            California           CA               Mission Viejo
## 121            California           CA                     Hayward
## 122            California           CA                   Hawthorne
## 123            California           CA                   Montclair
## 124            California           CA                    Redlands
## 125            California           CA                 San Jacinto
## 126            California           CA                    Milpitas
## 127            California           CA                   Yuba City
## 128            California           CA             Huntington Park
## 129            California           CA                 Simi Valley
## 130            California           CA                 Westminster
## 131            California           CA                    Torrance
## 132            California           CA                    Cerritos
## 133            California           CA                     Redding
## 134            California           CA                   Fairfield
## 135            California           CA                Garden Grove
## 136            California           CA                      Delano
## 137            California           CA  San Buenaventura (Ventura)
## 138            California           CA                     Fremont
## 139            California           CA                   Brentwood
## 140            California           CA                 West Covina
## 141            California           CA                    Richmond
## 142            California           CA                     Menifee
## 143            California           CA                    Pasadena
## 144            California           CA                     Antioch
## 145            California           CA                       Davis
## 146            California           CA                     Hanford
## 147            California           CA                   La Puente
## 148            California           CA                    Rosemead
## 149            California           CA                 Diamond Bar
## 150            California           CA                       Poway
## 151            California           CA                Baldwin Park
## 152            California           CA                 Chino Hills
## 153            California           CA                  Santa Cruz
## 154            California           CA                      Corona
## 155            California           CA                Apple Valley
## 156            California           CA                 Chula Vista
## 157            California           CA               Thousand Oaks
## 158            California           CA                     Concord
## 159            California           CA         South San Francisco
## 160            California           CA                    Danville
## 161            California           CA                     Visalia
## 162            California           CA                       Azusa
## 163            California           CA                Redwood City
## 164            California           CA                 Porterville
## 165            California           CA                   La Quinta
## 166            California           CA                   Escondido
## 167            California           CA                   Encinitas
## 168            California           CA                  Pleasanton
## 169            California           CA                       Tracy
## 170            California           CA                     La Mesa
## 171            California           CA                   Fullerton
## 172            California           CA                       Vista
## 173            California           CA                   Cupertino
## 174            California           CA                 Morgan Hill
## 175            California           CA                      Gilroy
## 176            California           CA                 Aliso Viejo
## 177            California           CA                     Gardena
## 178            California           CA                 San Leandro
## 179            California           CA                 Victorville
## 180            California           CA                     Compton
## 181            California           CA                       Indio
## 182            California           CA               Mountain View
## 183            California           CA                  Union City
## 184            California           CA             Fountain Valley
## 185            California           CA            Huntington Beach
## 186            California           CA                  Costa Mesa
## 187            California           CA                       Chino
## 188            California           CA                   Camarillo
## 189            California           CA                   Inglewood
## 190            California           CA                    Eastvale
## 191            California           CA                     Lincoln
## 192            California           CA               National City
## 193            California           CA                      Novato
## 194            California           CA                    El Monte
## 195            California           CA                   Palo Alto
## 196            California           CA                    Pacifica
## 197            California           CA                      Covina
## 198            California           CA                 Culver City
## 199            California           CA                     Manteca
## 200            California           CA                    Martinez
## 201            California           CA                     Yucaipa
## 202            California           CA                 Watsonville
## 203            California           CA                    El Cajon
## 204            California           CA                     Lynwood
## 205            California           CA                      Newark
## 206            California           CA                      Irvine
## 207            California           CA                 Lake Forest
## 208            California           CA                 Palm Desert
## 209            California           CA              Cathedral City
## 210            California           CA                     Arcadia
## 211            California           CA                   San Bruno
## 212            California           CA                  Long Beach
## 213            California           CA                      Downey
## 214            California           CA                   El Centro
## 215            California           CA                      Upland
## 216            California           CA                    Calexico
## 217            California           CA                      Lompoc
## 218            California           CA                Bell Gardens
## 219            California           CA                      Madera
## 220            California           CA                 Santa Clara
## 221            California           CA                   Paramount
## 222            California           CA                      Dublin
## 223            California           CA      Rancho Santa Margarita
## 224            California           CA                      Colton
## 225            California           CA         Rancho Palos Verdes
## 226            California           CA                  Buena Park
## 227            California           CA                  Bellflower
## 228            California           CA                      Tulare
## 229            California           CA                      Oakley
## 230            California           CA                Rohnert Park
## 231            California           CA                    Glendora
## 232            California           CA                      Folsom
## 233            California           CA                     Stanton
## 234            California           CA                       Hemet
## 235            California           CA                     Rocklin
## 236            California           CA                   Coachella
## 237            California           CA                    Campbell
## 238            California           CA             West Sacramento
## 239            California           CA                   La Mirada
## 240            California           CA                     Salinas
## 241            California           CA                    Woodland
## 242            California           CA                    Whittier
## 243            California           CA                    Petaluma
## 244            California           CA                    Lakewood
## 245            California           CA                     Cypress
## 246            California           CA                    La Habra
## 247            California           CA                   Roseville
## 248            California           CA                        Brea
## 249            California           CA               Redondo Beach
## 250            California           CA               Lake Elsinore
## 251            California           CA                    Beaumont
## 252            California           CA               Santa Barbara
## 253            California           CA                 Pico Rivera
## 254            California           CA                   Pittsburg
## 255            California           CA              Rancho Cordova
## 256            California           CA                       Ceres
## 257            California           CA                   Placentia
## 258            California           CA                 San Gabriel
## 259            California           CA                    Hesperia
## 260            California           CA                    Highland
## 261              Colorado           CO                  Centennial
## 262              Colorado           CO                    Thornton
## 263              Colorado           CO                    Lakewood
## 264              Colorado           CO                      Parker
## 265              Colorado           CO                      Pueblo
## 266              Colorado           CO                     Greeley
## 267              Colorado           CO                    Loveland
## 268              Colorado           CO                 Castle Rock
## 269              Colorado           CO               Commerce City
## 270              Colorado           CO                Fort Collins
## 271              Colorado           CO                   Littleton
## 272              Colorado           CO                 Westminster
## 273              Colorado           CO            Colorado Springs
## 274              Colorado           CO                      Denver
## 275              Colorado           CO                    Longmont
## 276              Colorado           CO                      Aurora
## 277              Colorado           CO                      Arvada
## 278              Colorado           CO                  Northglenn
## 279              Colorado           CO              Grand Junction
## 280              Colorado           CO                  Broomfield
## 281              Colorado           CO                     Boulder
## 282           Connecticut           CT                  Bridgeport
## 283           Connecticut           CT                     Danbury
## 284           Connecticut           CT                 New Britain
## 285           Connecticut           CT                  Middletown
## 286           Connecticut           CT                    Stamford
## 287           Connecticut           CT                   New Haven
## 288           Connecticut           CT                     Milford
## 289           Connecticut           CT                    Hartford
## 290           Connecticut           CT                  West Haven
## 291           Connecticut           CT                     Norwalk
## 292           Connecticut           CT                     Bristol
## 293           Connecticut           CT                     Meriden
## 294           Connecticut           CT                     Shelton
## 295           Connecticut           CT                   Waterbury
## 296           Connecticut           CT                     Norwich
## 297              Delaware           DE                  Wilmington
## 298              Delaware           DE                       Dover
## 299  District of Columbia           DC                  Washington
## 300               Florida           FL                  Lauderhill
## 301               Florida           FL                 Tallahassee
## 302               Florida           FL               Miami Gardens
## 303               Florida           FL           North Miami Beach
## 304               Florida           FL                       Doral
## 305               Florida           FL                    Lakeland
## 306               Florida           FL                     Tamarac
## 307               Florida           FL             Fort Lauderdale
## 308               Florida           FL                  Clearwater
## 309               Florida           FL                    Sarasota
## 310               Florida           FL           Altamonte Springs
## 311               Florida           FL                    Palm Bay
## 312               Florida           FL                 Gainesville
## 313               Florida           FL                  Titusville
## 314               Florida           FL                Delray Beach
## 315               Florida           FL          Palm Beach Gardens
## 316               Florida           FL               Coconut Creek
## 317               Florida           FL               Pinellas Park
## 318               Florida           FL                   St. Cloud
## 319               Florida           FL                 Port Orange
## 320               Florida           FL                   Bradenton
## 321               Florida           FL               Winter Garden
## 322               Florida           FL                     Deltona
## 323               Florida           FL                      Weston
## 324               Florida           FL                       Largo
## 325               Florida           FL                Coral Gables
## 326               Florida           FL                       Miami
## 327               Florida           FL                   Homestead
## 328               Florida           FL                     Miramar
## 329               Florida           FL                  North Port
## 330               Florida           FL                 Fort Pierce
## 331               Florida           FL                   Kissimmee
## 332               Florida           FL                   Pensacola
## 333               Florida           FL                  Palm Coast
## 334               Florida           FL                Jacksonville
## 335               Florida           FL                 Miami Beach
## 336               Florida           FL             West Palm Beach
## 337               Florida           FL              Pembroke Pines
## 338               Florida           FL                     Jupiter
## 339               Florida           FL                  Plantation
## 340               Florida           FL                Ormond Beach
## 341               Florida           FL               Pompano Beach
## 342               Florida           FL                     Margate
## 343               Florida           FL                       Ocoee
## 344               Florida           FL                     Orlando
## 345               Florida           FL                     Hialeah
## 346               Florida           FL                      Apopka
## 347               Florida           FL                       Davie
## 348               Florida           FL                   Melbourne
## 349               Florida           FL                Oakland Park
## 350               Florida           FL                   Hollywood
## 351               Florida           FL                 Panama City
## 352               Florida           FL            Hallandale Beach
## 353               Florida           FL               Coral Springs
## 354               Florida           FL                     Sunrise
## 355               Florida           FL              St. Petersburg
## 356               Florida           FL               Boynton Beach
## 357               Florida           FL                       Tampa
## 358               Florida           FL               Daytona Beach
## 359               Florida           FL                  Fort Myers
## 360               Florida           FL                  Cape Coral
## 361               Florida           FL              Bonita Springs
## 362               Florida           FL                 North Miami
## 363               Florida           FL                  Boca Raton
## 364               Florida           FL            North Lauderdale
## 365               Florida           FL                     Sanford
## 366               Florida           FL                  Greenacres
## 367               Florida           FL              Port St. Lucie
## 368               Florida           FL                    Aventura
## 369               Florida           FL             Deerfield Beach
## 370               Florida           FL                  Cutler Bay
## 371               Florida           FL                       Ocala
## 372               Florida           FL                  Wellington
## 373               Georgia           GA                     Atlanta
## 374               Georgia           GA                    Marietta
## 375               Georgia           GA                     Roswell
## 376               Georgia           GA                      Smyrna
## 377               Georgia           GA           Peachtree Corners
## 378               Georgia           GA               Sandy Springs
## 379               Georgia           GA                 Johns Creek
## 380               Georgia           GA        Athens-Clarke County
## 381               Georgia           GA                    Columbus
## 382               Georgia           GA                    Dunwoody
## 383               Georgia           GA     Augusta-Richmond County
## 384               Georgia           GA                    Valdosta
## 385               Georgia           GA                      Albany
## 386               Georgia           GA               Warner Robins
## 387               Georgia           GA                       Macon
## 388               Georgia           GA                  Brookhaven
## 389               Georgia           GA                    Savannah
## 390               Georgia           GA                  Alpharetta
## 391                Hawaii           HI                    Honolulu
## 392                 Idaho           ID                 Idaho Falls
## 393                 Idaho           ID                  Twin Falls
## 394                 Idaho           ID                   Pocatello
## 395                 Idaho           ID                    Caldwell
## 396                 Idaho           ID                    Meridian
## 397                 Idaho           ID               Coeur d'Alene
## 398                 Idaho           ID                       Nampa
## 399                 Idaho           ID                  Boise City
## 400              Illinois           IL                Carol Stream
## 401              Illinois           IL                       Elgin
## 402              Illinois           IL                    Rockford
## 403              Illinois           IL                      Cicero
## 404              Illinois           IL                  Streamwood
## 405              Illinois           IL                      Quincy
## 406              Illinois           IL                  Park Ridge
## 407              Illinois           IL                      Skokie
## 408              Illinois           IL                    Bartlett
## 409              Illinois           IL                      Moline
## 410              Illinois           IL                      DeKalb
## 411              Illinois           IL                    Oak Lawn
## 412              Illinois           IL                 Bolingbrook
## 413              Illinois           IL                      Joliet
## 414              Illinois           IL                      Normal
## 415              Illinois           IL                    Waukegan
## 416              Illinois           IL             Carpentersville
## 417              Illinois           IL                Crystal Lake
## 418              Illinois           IL               Buffalo Grove
## 419              Illinois           IL                  Naperville
## 420              Illinois           IL                     Lombard
## 421              Illinois           IL                      Peoria
## 422              Illinois           IL           Arlington Heights
## 423              Illinois           IL                 Orland Park
## 424              Illinois           IL                    Elmhurst
## 425              Illinois           IL                Hanover Park
## 426              Illinois           IL                   Champaign
## 427              Illinois           IL                 Tinley Park
## 428              Illinois           IL               Downers Grove
## 429              Illinois           IL              Mount Prospect
## 430              Illinois           IL                    Glenview
## 431              Illinois           IL                      Aurora
## 432              Illinois           IL                  Schaumburg
## 433              Illinois           IL                  Romeoville
## 434              Illinois           IL                     Chicago
## 435              Illinois           IL                  Plainfield
## 436              Illinois           IL                      Berwyn
## 437              Illinois           IL                 Des Plaines
## 438              Illinois           IL                     Decatur
## 439              Illinois           IL                      Urbana
## 440              Illinois           IL                    Oak Park
## 441              Illinois           IL                 Rock Island
## 442              Illinois           IL                     Wheaton
## 443              Illinois           IL                    Palatine
## 444              Illinois           IL                 Springfield
## 445              Illinois           IL                     Addison
## 446              Illinois           IL                  Belleville
## 447              Illinois           IL                Calumet City
## 448              Illinois           IL                    Wheeling
## 449              Illinois           IL                 Bloomington
## 450              Illinois           IL                    Evanston
## 451              Illinois           IL             Hoffman Estates
## 452               Indiana           IN                        Gary
## 453               Indiana           IN                 Terre Haute
## 454               Indiana           IN                Indianapolis
## 455               Indiana           IN                 Bloomington
## 456               Indiana           IN                   Lafayette
## 457               Indiana           IN                 Noblesville
## 458               Indiana           IN                   Mishawaka
## 459               Indiana           IN                      Muncie
## 460               Indiana           IN                      Carmel
## 461               Indiana           IN                    Columbus
## 462               Indiana           IN                      Kokomo
## 463               Indiana           IN                     Hammond
## 464               Indiana           IN                    Anderson
## 465               Indiana           IN                   Greenwood
## 466               Indiana           IN                    Lawrence
## 467               Indiana           IN                     Elkhart
## 468               Indiana           IN                  Evansville
## 469               Indiana           IN              Jeffersonville
## 470               Indiana           IN                     Fishers
## 471               Indiana           IN                  South Bend
## 472               Indiana           IN                  Fort Wayne
## 473                  Iowa           IA                   Iowa City
## 474                  Iowa           IA                Cedar Rapids
## 475                  Iowa           IA                   Davenport
## 476                  Iowa           IA                  Sioux City
## 477                  Iowa           IA                        Ames
## 478                  Iowa           IA                     Dubuque
## 479                  Iowa           IA                      Ankeny
## 480                  Iowa           IA             West Des Moines
## 481                  Iowa           IA              Council Bluffs
## 482                  Iowa           IA                  Des Moines
## 483                  Iowa           IA                   Urbandale
## 484                  Iowa           IA                 Cedar Falls
## 485                  Iowa           IA                    Waterloo
## 486                Kansas           KS               Overland Park
## 487                Kansas           KS                     Wichita
## 488                Kansas           KS                      Salina
## 489                Kansas           KS                      Lenexa
## 490                Kansas           KS                      Topeka
## 491                Kansas           KS                 Kansas City
## 492                Kansas           KS                  Hutchinson
## 493                Kansas           KS                      Olathe
## 494                Kansas           KS                    Lawrence
## 495                Kansas           KS                   Manhattan
## 496                Kansas           KS                     Shawnee
## 497              Kentucky           KY                   Owensboro
## 498              Kentucky           KY           Lexington-Fayette
## 499              Kentucky           KY               Bowling Green
## 500              Kentucky           KY Louisville/Jefferson County
## 501              Kentucky           KY                   Covington
## 502             Louisiana           LA                Bossier City
## 503             Louisiana           LA                  Alexandria
## 504             Louisiana           LA                      Kenner
## 505             Louisiana           LA                  Shreveport
## 506             Louisiana           LA                 New Orleans
## 507             Louisiana           LA                Lake Charles
## 508             Louisiana           LA                      Monroe
## 509             Louisiana           LA                 Baton Rouge
## 510             Louisiana           LA                   Lafayette
## 511                 Maine           ME                    Portland
## 512              Maryland           MD                   Rockville
## 513              Maryland           MD                       Bowie
## 514              Maryland           MD                   Frederick
## 515              Maryland           MD                   Baltimore
## 516              Maryland           MD                Gaithersburg
## 517              Maryland           MD                  Hagerstown
## 518              Maryland           MD                   Annapolis
## 519         Massachusetts           MA                   Westfield
## 520         Massachusetts           MA                     Medford
## 521         Massachusetts           MA                     Everett
## 522         Massachusetts           MA                    Lawrence
## 523         Massachusetts           MA                 New Bedford
## 524         Massachusetts           MA                      Newton
## 525         Massachusetts           MA             Barnstable Town
## 526         Massachusetts           MA                     Peabody
## 527         Massachusetts           MA                        Lynn
## 528         Massachusetts           MA                      Quincy
## 529         Massachusetts           MA                  Leominster
## 530         Massachusetts           MA               Weymouth Town
## 531         Massachusetts           MA                   Fitchburg
## 532         Massachusetts           MA                      Lowell
## 533         Massachusetts           MA                 Marlborough
## 534         Massachusetts           MA                     Holyoke
## 535         Massachusetts           MA                   Attleboro
## 536         Massachusetts           MA                    Chicopee
## 537         Massachusetts           MA                     Taunton
## 538         Massachusetts           MA                    Brockton
## 539         Massachusetts           MA                   Haverhill
## 540         Massachusetts           MA                     Waltham
## 541         Massachusetts           MA                   Cambridge
## 542         Massachusetts           MA                      Woburn
## 543         Massachusetts           MA                  Pittsfield
## 544         Massachusetts           MA                     Beverly
## 545         Massachusetts           MA                      Boston
## 546         Massachusetts           MA                   Worcester
## 547         Massachusetts           MA                     Methuen
## 548         Massachusetts           MA                  Somerville
## 549         Massachusetts           MA                      Revere
## 550         Massachusetts           MA                  Fall River
## 551         Massachusetts           MA                      Malden
## 552         Massachusetts           MA                     Chelsea
## 553         Massachusetts           MA                 Springfield
## 554         Massachusetts           MA                       Salem
## 555              Michigan           MI                     Livonia
## 556              Michigan           MI                Battle Creek
## 557              Michigan           MI            Dearborn Heights
## 558              Michigan           MI                   Roseville
## 559              Michigan           MI                   Royal Oak
## 560              Michigan           MI                  Southfield
## 561              Michigan           MI                    Westland
## 562              Michigan           MI                    Kentwood
## 563              Michigan           MI                     Midland
## 564              Michigan           MI                East Lansing
## 565              Michigan           MI                     Portage
## 566              Michigan           MI                    Dearborn
## 567              Michigan           MI             Rochester Hills
## 568              Michigan           MI                     Pontiac
## 569              Michigan           MI                      Taylor
## 570              Michigan           MI                       Flint
## 571              Michigan           MI                     Lansing
## 572              Michigan           MI                Grand Rapids
## 573              Michigan           MI                    Muskegon
## 574              Michigan           MI            Farmington Hills
## 575              Michigan           MI                Lincoln Park
## 576              Michigan           MI            St. Clair Shores
## 577              Michigan           MI                        Troy
## 578              Michigan           MI                      Warren
## 579              Michigan           MI                     Saginaw
## 580              Michigan           MI                        Novi
## 581              Michigan           MI                   Ann Arbor
## 582              Michigan           MI            Sterling Heights
## 583              Michigan           MI                     Detroit
## 584              Michigan           MI                     Wyoming
## 585              Michigan           MI                   Kalamazoo
## 586             Minnesota           MN                 Bloomington
## 587             Minnesota           MN                Apple Valley
## 588             Minnesota           MN               Brooklyn Park
## 589             Minnesota           MN                    Moorhead
## 590             Minnesota           MN                   Rochester
## 591             Minnesota           MN                    Woodbury
## 592             Minnesota           MN                 Coon Rapids
## 593             Minnesota           MN                    Plymouth
## 594             Minnesota           MN                       Eagan
## 595             Minnesota           MN                   Lakeville
## 596             Minnesota           MN                    St. Paul
## 597             Minnesota           MN              St. Louis Park
## 598             Minnesota           MN                 Maple Grove
## 599             Minnesota           MN                      Duluth
## 600             Minnesota           MN                   Maplewood
## 601             Minnesota           MN                    Shakopee
## 602             Minnesota           MN                     Mankato
## 603             Minnesota           MN                   St. Cloud
## 604             Minnesota           MN                      Blaine
## 605             Minnesota           MN                       Edina
## 606             Minnesota           MN                 Minneapolis
## 607             Minnesota           MN                  Minnetonka
## 608             Minnesota           MN                Eden Prairie
## 609             Minnesota           MN                  Burnsville
## 610           Mississippi           MS                   Southaven
## 611           Mississippi           MS                     Jackson
## 612           Mississippi           MS                    Meridian
## 613           Mississippi           MS                 Hattiesburg
## 614           Mississippi           MS                    Gulfport
## 615           Mississippi           MS                      Biloxi
## 616              Missouri           MO              Jefferson City
## 617              Missouri           MO                 Springfield
## 618              Missouri           MO                Independence
## 619              Missouri           MO                Lee's Summit
## 620              Missouri           MO                      Joplin
## 621              Missouri           MO                Chesterfield
## 622              Missouri           MO                Blue Springs
## 623              Missouri           MO                 St. Charles
## 624              Missouri           MO              Cape Girardeau
## 625              Missouri           MO                   St. Louis
## 626              Missouri           MO                 Kansas City
## 627              Missouri           MO                  Florissant
## 628              Missouri           MO                    Columbia
## 629              Missouri           MO                  St. Joseph
## 630              Missouri           MO                    O'Fallon
## 631              Missouri           MO                  St. Peters
## 632               Montana           MT                    Billings
## 633               Montana           MT                 Great Falls
## 634               Montana           MT                    Missoula
## 635               Montana           MT                     Bozeman
## 636              Nebraska           NE                    Bellevue
## 637              Nebraska           NE                Grand Island
## 638              Nebraska           NE                     Lincoln
## 639              Nebraska           NE                       Omaha
## 640                Nevada           NV                        Reno
## 641                Nevada           NV                   Las Vegas
## 642                Nevada           NV                 Carson City
## 643                Nevada           NV                   Henderson
## 644                Nevada           NV             North Las Vegas
## 645                Nevada           NV                      Sparks
## 646         New Hampshire           NH                     Concord
## 647         New Hampshire           NH                  Manchester
## 648         New Hampshire           NH                      Nashua
## 649            New Jersey           NJ                     Trenton
## 650            New Jersey           NJ               West New York
## 651            New Jersey           NJ                     Clifton
## 652            New Jersey           NJ                  Sayreville
## 653            New Jersey           NJ                     Hoboken
## 654            New Jersey           NJ                   Elizabeth
## 655            New Jersey           NJ                    Vineland
## 656            New Jersey           NJ                 Perth Amboy
## 657            New Jersey           NJ                     Passaic
## 658            New Jersey           NJ                      Kearny
## 659            New Jersey           NJ                      Camden
## 660            New Jersey           NJ                      Newark
## 661            New Jersey           NJ                 Jersey City
## 662            New Jersey           NJ                  Plainfield
## 663            New Jersey           NJ                     Bayonne
## 664            New Jersey           NJ                      Linden
## 665            New Jersey           NJ               Atlantic City
## 666            New Jersey           NJ                  Hackensack
## 667            New Jersey           NJ                 East Orange
## 668            New Jersey           NJ               New Brunswick
## 669            New Jersey           NJ                  Union City
## 670            New Jersey           NJ                    Paterson
## 671            New Mexico           NM                  Las Cruces
## 672            New Mexico           NM                  Farmington
## 673            New Mexico           NM                    Santa Fe
## 674            New Mexico           NM                      Clovis
## 675            New Mexico           NM                 Albuquerque
## 676            New Mexico           NM                     Roswell
## 677            New Mexico           NM                  Rio Rancho
## 678              New York           NY                    Freeport
## 679              New York           NY                   Rochester
## 680              New York           NY                        Troy
## 681              New York           NY                     Buffalo
## 682              New York           NY                      Albany
## 683              New York           NY                 Schenectady
## 684              New York           NY                     Yonkers
## 685              New York           NY                White Plains
## 686              New York           NY               Niagara Falls
## 687              New York           NY                  Binghamton
## 688              New York           NY               Valley Stream
## 689              New York           NY                       Utica
## 690              New York           NY                    Syracuse
## 691              New York           NY                New Rochelle
## 692              New York           NY                Mount Vernon
## 693              New York           NY                    New York
## 694              New York           NY                   Hempstead
## 695        North Carolina           NC                  Wilmington
## 696        North Carolina           NC                      Wilson
## 697        North Carolina           NC                     Hickory
## 698        North Carolina           NC                  Greensboro
## 699        North Carolina           NC                        Apex
## 700        North Carolina           NC                Jacksonville
## 701        North Carolina           NC                  High Point
## 702        North Carolina           NC                Huntersville
## 703        North Carolina           NC                  Greenville
## 704        North Carolina           NC                Fayetteville
## 705        North Carolina           NC                 Chapel Hill
## 706        North Carolina           NC                        Cary
## 707        North Carolina           NC                   Asheville
## 708        North Carolina           NC               Winston-Salem
## 709        North Carolina           NC                   Charlotte
## 710        North Carolina           NC                  Burlington
## 711        North Carolina           NC                     Concord
## 712        North Carolina           NC                      Durham
## 713        North Carolina           NC                  Kannapolis
## 714        North Carolina           NC                     Raleigh
## 715        North Carolina           NC                 Rocky Mount
## 716        North Carolina           NC                    Gastonia
## 717          North Dakota           ND                    Bismarck
## 718          North Dakota           ND                       Fargo
## 719          North Dakota           ND                       Minot
## 720          North Dakota           ND                 Grand Forks
## 721                  Ohio           OH                      Euclid
## 722                  Ohio           OH                  Cincinnati
## 723                  Ohio           OH               Huber Heights
## 724                  Ohio           OH                      Lorain
## 725                  Ohio           OH                 Beavercreek
## 726                  Ohio           OH                      Canton
## 727                  Ohio           OH                      Elyria
## 728                  Ohio           OH                   Cleveland
## 729                  Ohio           OH                     Findlay
## 730                  Ohio           OH                  Grove City
## 731                  Ohio           OH                 Westerville
## 732                  Ohio           OH                      Toledo
## 733                  Ohio           OH                   Kettering
## 734                  Ohio           OH                       Akron
## 735                  Ohio           OH                   Fairfield
## 736                  Ohio           OH                Strongsville
## 737                  Ohio           OH                    Hamilton
## 738                  Ohio           OH                 Springfield
## 739                  Ohio           OH                    Lakewood
## 740                  Ohio           OH                        Lima
## 741                  Ohio           OH                   Lancaster
## 742                  Ohio           OH                   Mansfield
## 743                  Ohio           OH                  Youngstown
## 744                  Ohio           OH                    Columbus
## 745                  Ohio           OH                      Dublin
## 746                  Ohio           OH                      Mentor
## 747                  Ohio           OH              Cuyahoga Falls
## 748                  Ohio           OH                      Warren
## 749                  Ohio           OH           Cleveland Heights
## 750                  Ohio           OH                      Dayton
## 751                  Ohio           OH                       Parma
## 752                  Ohio           OH                      Newark
## 753                  Ohio           OH                  Middletown
## 754              Oklahoma           OK                    Muskogee
## 755              Oklahoma           OK                       Tulsa
## 756              Oklahoma           OK               Oklahoma City
## 757              Oklahoma           OK                Midwest City
## 758              Oklahoma           OK                      Edmond
## 759              Oklahoma           OK                      Norman
## 760              Oklahoma           OK                Broken Arrow
## 761              Oklahoma           OK                        Enid
## 762              Oklahoma           OK                  Stillwater
## 763              Oklahoma           OK                      Lawton
## 764              Oklahoma           OK                       Moore
## 765                Oregon           OR                      Tigard
## 766                Oregon           OR                   Corvallis
## 767                Oregon           OR                      Keizer
## 768                Oregon           OR                     Gresham
## 769                Oregon           OR                   Hillsboro
## 770                Oregon           OR                      Albany
## 771                Oregon           OR                   Beaverton
## 772                Oregon           OR                    Portland
## 773                Oregon           OR                 Springfield
## 774                Oregon           OR                      Eugene
## 775                Oregon           OR                     Medford
## 776                Oregon           OR                        Bend
## 777                Oregon           OR                       Salem
## 778                Oregon           OR                 Lake Oswego
## 779          Pennsylvania           PA                Wilkes-Barre
## 780          Pennsylvania           PA               State College
## 781          Pennsylvania           PA                Philadelphia
## 782          Pennsylvania           PA                   Lancaster
## 783          Pennsylvania           PA                        York
## 784          Pennsylvania           PA                    Scranton
## 785          Pennsylvania           PA                  Harrisburg
## 786          Pennsylvania           PA                     Altoona
## 787          Pennsylvania           PA                   Bethlehem
## 788          Pennsylvania           PA                     Reading
## 789          Pennsylvania           PA                        Erie
## 790          Pennsylvania           PA                  Pittsburgh
## 791          Pennsylvania           PA                   Allentown
## 792          Rhode Island           RI                    Cranston
## 793          Rhode Island           RI                     Warwick
## 794          Rhode Island           RI             East Providence
## 795          Rhode Island           RI                  Providence
## 796          Rhode Island           RI                  Woonsocket
## 797          Rhode Island           RI                   Pawtucket
## 798        South Carolina           SC                  Greenville
## 799        South Carolina           SC                    Columbia
## 800        South Carolina           SC                  Charleston
## 801        South Carolina           SC                      Sumter
## 802        South Carolina           SC                 Summerville
## 803        South Carolina           SC                 Spartanburg
## 804        South Carolina           SC              Mount Pleasant
## 805        South Carolina           SC          Hilton Head Island
## 806        South Carolina           SC                   Rock Hill
## 807        South Carolina           SC                 Goose Creek
## 808        South Carolina           SC            North Charleston
## 809        South Carolina           SC                    Florence
## 810          South Dakota           SD                 Sioux Falls
## 811          South Dakota           SD                  Rapid City
## 812             Tennessee           TN                Murfreesboro
## 813             Tennessee           TN                   Kingsport
## 814             Tennessee           TN          Nashville-Davidson
## 815             Tennessee           TN                   Knoxville
## 816             Tennessee           TN                  Germantown
## 817             Tennessee           TN                    Bartlett
## 818             Tennessee           TN                Johnson City
## 819             Tennessee           TN                Collierville
## 820             Tennessee           TN                     Jackson
## 821             Tennessee           TN                     Memphis
## 822             Tennessee           TN                      Smyrna
## 823             Tennessee           TN                 Clarksville
## 824             Tennessee           TN              Hendersonville
## 825             Tennessee           TN                   Cleveland
## 826             Tennessee           TN                   Brentwood
## 827             Tennessee           TN                    Franklin
## 828             Tennessee           TN                 Chattanooga
## 829                 Texas           TX                  Richardson
## 830                 Texas           TX                  Carrollton
## 831                 Texas           TX                 Port Arthur
## 832                 Texas           TX                  Huntsville
## 833                 Texas           TX              Corpus Christi
## 834                 Texas           TX               New Braunfels
## 835                 Texas           TX                      Austin
## 836                 Texas           TX                  Lewisville
## 837                 Texas           TX                 League City
## 838                 Texas           TX                     Coppell
## 839                 Texas           TX                     Sherman
## 840                 Texas           TX                    Pearland
## 841                 Texas           TX                  Fort Worth
## 842                 Texas           TX                Flower Mound
## 843                 Texas           TX                 Friendswood
## 844                 Texas           TX        North Richland Hills
## 845                 Texas           TX                   Arlington
## 846                 Texas           TX                  Texas City
## 847                 Texas           TX                      Temple
## 848                 Texas           TX                      Conroe
## 849                 Texas           TX                   Galveston
## 850                 Texas           TX               Wichita Falls
## 851                 Texas           TX                     Houston
## 852                 Texas           TX                       Allen
## 853                 Texas           TX                     Lubbock
## 854                 Texas           TX                  Georgetown
## 855                 Texas           TX                 Brownsville
## 856                 Texas           TX                  Cedar Park
## 857                 Texas           TX               Grand Prairie
## 858                 Texas           TX                       Pharr
## 859                 Texas           TX                      Frisco
## 860                 Texas           TX                      Irving
## 861                 Texas           TX                      Laredo
## 862                 Texas           TX                    Mesquite
## 863                 Texas           TX                   Harlingen
## 864                 Texas           TX                   Mansfield
## 865                 Texas           TX                   Texarkana
## 866                 Texas           TX                  San Angelo
## 867                 Texas           TX                       Hurst
## 868                 Texas           TX                  Round Rock
## 869                 Texas           TX                       Tyler
## 870                 Texas           TX                    Victoria
## 871                 Texas           TX                    Beaumont
## 872                 Texas           TX                Pflugerville
## 873                 Texas           TX                     McAllen
## 874                 Texas           TX                       Bryan
## 875                 Texas           TX                    Burleson
## 876                 Texas           TX                  Sugar Land
## 877                 Texas           TX                      Denton
## 878                 Texas           TX                     Weslaco
## 879                 Texas           TX                    Longview
## 880                 Texas           TX                    McKinney
## 881                 Texas           TX                      Dallas
## 882                 Texas           TX                    Rockwall
## 883                 Texas           TX                    Pasadena
## 884                 Texas           TX                     Mission
## 885                 Texas           TX             College Station
## 886                 Texas           TX                    Amarillo
## 887                 Texas           TX                       Wylie
## 888                 Texas           TX                    Edinburg
## 889                 Texas           TX               Missouri City
## 890                 Texas           TX                       Plano
## 891                 Texas           TX                  San Marcos
## 892                 Texas           TX                     Bedford
## 893                 Texas           TX                     Abilene
## 894                 Texas           TX                     El Paso
## 895                 Texas           TX                     Baytown
## 896                 Texas           TX                  The Colony
## 897                 Texas           TX                 Haltom City
## 898                 Texas           TX                     Killeen
## 899                 Texas           TX                   Lancaster
## 900                 Texas           TX                     Garland
## 901                 Texas           TX                     Midland
## 902                 Texas           TX                   Grapevine
## 903                 Texas           TX                 Duncanville
## 904                 Texas           TX                      Euless
## 905                 Texas           TX                      DeSoto
## 906                 Texas           TX                  Cedar Hill
## 907                 Texas           TX                        Waco
## 908                 Texas           TX                     Rowlett
## 909                 Texas           TX                 San Antonio
## 910                 Texas           TX                      Keller
## 911                 Texas           TX                      Odessa
## 912                  Utah           UT                        Lehi
## 913                  Utah           UT                Spanish Fork
## 914                  Utah           UT                       Sandy
## 915                  Utah           UT                  St. George
## 916                  Utah           UT                South Jordan
## 917                  Utah           UT                        Orem
## 918                  Utah           UT            West Valley City
## 919                  Utah           UT                       Provo
## 920                  Utah           UT                       Logan
## 921                  Utah           UT                      Layton
## 922                  Utah           UT                    Riverton
## 923                  Utah           UT                   Bountiful
## 924                  Utah           UT              Salt Lake City
## 925                  Utah           UT                      Murray
## 926                  Utah           UT                      Draper
## 927                  Utah           UT                         Roy
## 928                  Utah           UT                       Ogden
## 929                  Utah           UT                 West Jordan
## 930                  Utah           UT                Taylorsville
## 931               Vermont           VT                  Burlington
## 932              Virginia           VA                  Alexandria
## 933              Virginia           VA                  Blacksburg
## 934              Virginia           VA                  Portsmouth
## 935              Virginia           VA                     Hampton
## 936              Virginia           VA                Newport News
## 937              Virginia           VA                    Leesburg
## 938              Virginia           VA                    Danville
## 939              Virginia           VA             Charlottesville
## 940              Virginia           VA                   Lynchburg
## 941              Virginia           VA                    Manassas
## 942              Virginia           VA              Virginia Beach
## 943              Virginia           VA                  Chesapeake
## 944              Virginia           VA                    Richmond
## 945              Virginia           VA                     Roanoke
## 946              Virginia           VA                     Norfolk
## 947              Virginia           VA                Harrisonburg
## 948              Virginia           VA                     Suffolk
## 949            Washington           WA                   Kennewick
## 950            Washington           WA                    Bellevue
## 951            Washington           WA                   Shoreline
## 952            Washington           WA                   Sammamish
## 953            Washington           WA                       Lacey
## 954            Washington           WA                     Everett
## 955            Washington           WA                      Auburn
## 956            Washington           WA                      Yakima
## 957            Washington           WA                        Kent
## 958            Washington           WA                     Spokane
## 959            Washington           WA                    Puyallup
## 960            Washington           WA                    Lakewood
## 961            Washington           WA                 Federal Way
## 962            Washington           WA                       Pasco
## 963            Washington           WA                    Kirkland
## 964            Washington           WA              Spokane Valley
## 965            Washington           WA                      Renton
## 966            Washington           WA                   Vancouver
## 967            Washington           WA                     Seattle
## 968            Washington           WA                     Edmonds
## 969            Washington           WA                     Olympia
## 970            Washington           WA                    Richland
## 971            Washington           WA                  Bellingham
## 972            Washington           WA                   Bremerton
## 973            Washington           WA                  Marysville
## 974            Washington           WA                     Redmond
## 975            Washington           WA                      Burien
## 976            Washington           WA                      Tacoma
## 977         West Virginia           WV                  Charleston
## 978         West Virginia           WV                  Huntington
## 979             Wisconsin           WI                   Sheboygan
## 980             Wisconsin           WI                    Waukesha
## 981             Wisconsin           WI                  Brookfield
## 982             Wisconsin           WI                    Appleton
## 983             Wisconsin           WI                  Janesville
## 984             Wisconsin           WI                  West Allis
## 985             Wisconsin           WI                      Racine
## 986             Wisconsin           WI                   La Crosse
## 987             Wisconsin           WI                     Kenosha
## 988             Wisconsin           WI                  Eau Claire
## 989             Wisconsin           WI                      Wausau
## 990             Wisconsin           WI                  New Berlin
## 991             Wisconsin           WI                     Madison
## 992             Wisconsin           WI                   Wauwatosa
## 993             Wisconsin           WI                  Greenfield
## 994             Wisconsin           WI                     Oshkosh
## 995             Wisconsin           WI                 Fond du Lac
## 996             Wisconsin           WI                   Milwaukee
## 997             Wisconsin           WI                   Green Bay
## 998             Wisconsin           WI                      Beloit
## 999               Wyoming           WY                      Casper
## 1000              Wyoming           WY                    Cheyenne
##      growth_from_2000_to_2013 latitude  longitude population rank
## 1                       -1.9% 30.69537  -88.03989     194899  122
## 2                       31.9% 32.47098  -85.00077      37498  983
## 3                       -0.1% 32.36681  -86.29997     201332  111
## 4                        3.1% 34.60593  -86.98334      55816  653
## 5                       16.3% 34.73037  -86.58610     186254  126
## 6                       53.7% 34.69926  -86.74833      45799  811
## 7                       21.1% 33.20984  -87.56917      95334  313
## 8                       10.2% 34.79981  -87.67725      40059  922
## 9                       26.4% 32.60986  -85.48078      58582  615
## 10                      32.7% 33.40539  -86.81138      84126  376
## 11                      16.6% 31.22323  -85.39049      68001  502
## 12                     -12.3% 33.52066  -86.80249     212113  101
## 13                      15.4% 61.21806 -149.90028     300950   63
## 14                      86.0% 32.87950 -111.75735      50111  743
## 15                      96.0% 33.35283 -111.78903     229972   92
## 16                     281.9% 33.62923 -112.36793     123546  216
## 17                      11.0% 33.49417 -111.92605     226918   95
## 18                      15.9% 35.13594 -114.52860      39383  941
## 19                       5.7% 33.53865 -112.18599     234632   87
## 20                      18.1% 34.54002 -112.46850      40590  907
## 21                      13.5% 33.41518 -111.83147     457587   38
## 22                       5.8% 33.42551 -111.94001     168228  143
## 23                      29.3% 35.19828 -111.65130      68667  495
## 24                     166.2% 32.43638 -111.22244      38290  964
## 25                       7.5% 32.22174 -110.92648     526116   33
## 26                      15.7% 33.41505 -111.54958      37130  994
## 27                      62.9% 34.61002 -112.31572      39791  929
## 28                      46.5% 33.58060 -112.23738     162592  149
## 29                     111.5% 33.43560 -112.34960      78822  413
## 30                    2503.4% 33.05811 -112.04764      45508  817
## 31                      16.2% 32.69265 -114.62769      91923  330
## 32                      14.0% 33.44838 -112.07404    1513367    6
## 33                     271.0% 33.43534 -112.35766      72864  462
## 34                      38.7% 33.30616 -111.84125     249146   79
## 35                     480.9% 33.37032 -112.58378      56683  641
## 36                      27.0% 32.39091 -110.96649      41627  883
## 37                      19.3% 31.54550 -110.27729      45129  823
## 38                      24.6% 34.48390 -114.32245      52844  695
## 39                      97.7% 36.37285  -94.20882      40167  921
## 40                     -16.2% 34.22843  -92.00320      46094  805
## 41                      57.1% 36.18674  -94.12881      75229  443
## 42                      50.6% 36.33202  -94.11854      60112  591
## 43                      46.1% 35.08870  -92.44210      63816  546
## 44                       8.6% 35.38592  -94.39855      87650  355
## 45                       9.0% 34.76954  -92.26709      66075  524
## 46                      28.3% 35.84230  -90.70428      71551  469
## 47                      32.9% 36.06258  -94.15743      78960  411
## 48                       7.6% 34.74648  -92.28959     197357  118
## 49                      97.1% 38.40880 -121.37162     161007  151
## 50                       5.7% 32.83838 -116.97392      56105  648
## 51                       8.4% 38.29754 -122.28687      79068  409
## 52                      55.4% 33.49364 -117.14836     106780  266
## 53                       2.9% 33.83167 -118.28169      92599  325
## 54                       5.0% 37.97353 -122.53109      58994  609
## 55                       2.1% 34.05510 -117.74999     151348  162
## 56                       3.5% 37.91008 -122.06518      66900  513
## 57                       9.0% 37.56299 -122.32553     101128  286
## 58                      33.8% 34.68678 -118.15416     159523  153
## 59                      15.2% 38.44043 -122.71405     171990  140
## 60                       6.6% 33.19587 -117.37948     172794  137
## 61                     107.4% 33.55391 -117.21392     107479  263
## 62                      -0.7% 34.09529 -118.12701      84577  372
## 63                       5.5% 34.06334 -117.65089     167500  144
## 64                      15.1% 37.68187 -121.76801      85156  370
## 65                      15.3% 34.39166 -118.54259     179590  133
## 66                      28.6% 33.42697 -117.61199      65040  537
## 67                       7.7% 37.77493 -122.41942     837442   14
## 68                       4.8% 34.05223 -118.24368    3884307    2
## 69                      38.3% 34.09223 -117.43505     203003  109
## 70                      -0.8% 33.95474 -118.21202      95677  312
## 71                            33.99720 -117.48548      98030  300
## 72                       5.4% 37.76521 -122.24164      76419  435
## 73                      32.7% 34.10640 -117.59311     171386  141
## 74                      18.3% 36.74684 -119.77259     509924   34
## 75                      17.2% 38.58157 -121.49440     479686   35
## 76                       4.4% 35.28275 -120.65962      46377  802
## 77                       1.9% 33.90224 -118.08173     106589  267
## 78                       2.0% 34.01651 -118.11375      63495  549
## 79                      30.9% 34.95303 -120.43572     102216  281
## 80                      13.4% 33.88863 -117.81311      67032  511
## 81                      18.2% 34.19750 -119.17705     203007  108
## 82                       9.8% 34.10640 -117.37032     101910  284
## 83                      39.7% 33.15809 -117.35059     110972  244
## 84                       9.6% 34.01945 -118.49119      92472  326
## 85                       1.3% 37.80436 -122.27111     406253   45
## 86                      65.8% 37.77993 -121.97802      74513  449
## 87                      -0.1% 38.70712 -121.28106      85285  369
## 88                      10.5% 32.71574 -117.16108    1355896    8
## 89                      11.9% 37.36883 -122.03635     147559  170
## 90                      21.8% 37.95770 -121.29078     298118   64
## 91                      10.5% 37.33821 -121.88633     998537   10
## 92                      48.4% 35.37329 -119.01871     363630   52
## 93                       1.5% 34.06251 -118.12285      61085  577
## 94                       0.3% 34.14251 -118.25508     196021  121
## 95                       2.8% 33.52253 -117.70755      64652  539
## 96                       4.7% 33.83529 -117.91450     345012   56
## 97                      -1.2% 33.74557 -117.86783     334227   57
## 98                      15.6% 33.74585 -117.82617      78327  420
## 99                      22.5% 33.95335 -117.39616     316619   59
## 100                     13.0% 34.10834 -117.28977     213708  100
## 101                      7.7% 33.78779 -117.85311     139969  182
## 102                      1.2% 38.10409 -122.25664     118837  223
## 103                     98.7% 33.78252 -117.22865      72326  466
## 104                     60.0% 33.14337 -117.16614      89387  346
## 105                      7.7% 37.63910 -120.99688     204933  105
## 106                     10.1% 38.13415 -121.27222      63338  550
## 107                     42.6% 36.82523 -119.70292      99769  296
## 108                      0.2% 34.14426 -118.00195      37101  995
## 109                     14.2% 39.72849 -121.83748      88077  350
## 110                     13.3% 37.87159 -122.27275     116768  231
## 111                      1.0% 37.68792 -122.47021     104739  273
## 112                     40.4% 33.94247 -117.22967     201175  112
## 113                      4.2% 34.18084 -118.30897     104709  274
## 114                     10.4% 33.61891 -117.92895      87273  356
## 115                      5.4% 38.35658 -121.98774      94275  316
## 116                     33.7% 34.57943 -118.11646     157161  156
## 117                     25.4% 37.30216 -120.48297      81102  400
## 118                      7.7% 33.83030 -116.54529      46281  804
## 119                     23.5% 37.49466 -120.84659      70365  482
## 120                      2.9% 33.60002 -117.67200      96346  309
## 121                      7.5% 37.66882 -122.08080     151574  161
## 122                      2.3% 33.91640 -118.35257      86199  364
## 123                     12.1% 34.07751 -117.68978      38027  969
## 124                      9.4% 34.05557 -117.18254      69999  486
## 125                     91.8% 33.78391 -116.95864      45851  810
## 126                     11.0% 37.43233 -121.89957      69783  489
## 127                     27.9% 39.14045 -121.61691      65416  530
## 128                     -4.1% 33.98168 -118.22507      58879  612
## 129                     12.6% 34.26945 -118.78148     126181  210
## 130                      3.9% 33.75134 -117.99399      91739  331
## 131                      6.6% 33.83585 -118.34063     147478  171
## 132                     -3.6% 33.85835 -118.06479      49707  750
## 133                     11.9% 40.58654 -122.39168      91119  334
## 134                     12.8% 38.24936 -122.03997     109320  255
## 135                      5.8% 33.77391 -117.94145     175140  135
## 136                     31.8% 35.76884 -119.24705      52403  701
## 137                      7.4% 34.27465 -119.22903     108817  258
## 138                     10.0% 37.54827 -121.98857     224922   97
## 139                    122.3% 37.93187 -121.69579      55000  663
## 140                      2.3% 34.06862 -117.93895     107740  261
## 141                      7.9% 37.93576 -122.34775     107571  262
## 142                     95.0% 33.69715 -117.18529      83447  384
## 143                      3.8% 34.14778 -118.14452     139731  183
## 144                     16.9% 38.00492 -121.80579     107100  265
## 145                     11.9% 38.54491 -121.74052      66205  521
## 146                     30.3% 36.32745 -119.64568      54686  670
## 147                     -1.6% 34.02001 -117.94951      40435  911
## 148                      1.7% 34.08057 -118.07285      54561  672
## 149                      0.1% 34.02862 -117.81034      56449  646
## 150                      2.4% 32.96282 -117.03586      49417  755
## 151                      0.8% 34.08529 -117.96090      76635  433
## 152                     13.6% 33.98982 -117.73258      76572  434
## 153                     12.5% 36.97412 -122.03080      62864  556
## 154                     23.6% 33.87529 -117.56644     159503  154
## 155                     29.9% 34.50083 -117.18588      70924  477
## 156                     46.2% 32.64005 -117.08420     256780   75
## 157                      9.5% 34.17056 -118.83759     128731  198
## 158                      2.9% 37.97798 -122.03107     125880  211
## 159                      9.1% 37.65466 -122.40775      66174  522
## 160                      3.7% 37.82159 -121.99996      43341  846
## 161                     33.6% 36.33023 -119.29206     127763  201
## 162                      6.7% 34.13362 -117.90756      47842  780
## 163                      7.1% 37.48522 -122.23635      80872  403
## 164                     20.1% 36.06523 -119.01677      55174  661
## 165                     59.9% 33.66336 -116.31001      39331  943
## 166                     10.7% 33.11921 -117.08642     148738  166
## 167                      5.8% 33.03699 -117.29198      61588  570
## 168                     15.2% 37.66243 -121.87468      74110  450
## 169                     45.9% 37.73965 -121.42522      84691  371
## 170                      6.9% 32.76783 -117.02308      58642  613
## 171                      9.8% 33.87036 -117.92430     138981  184
## 172                      7.7% 33.20004 -117.24254      96929  306
## 173                     14.3% 37.32300 -122.03218      60189  589
## 174                     19.5% 37.13050 -121.65439      40836  900
## 175                     23.9% 37.00578 -121.56828      51701  712
## 176                     25.4% 33.56768 -117.72561      50175  741
## 177                      3.4% 33.88835 -118.30896      59957  593
## 178                     10.3% 37.72493 -122.15608      87965  352
## 179                     87.6% 34.53622 -117.29276     121096  218
## 180                      4.5% 33.89585 -118.22007      97877  301
## 181                     66.0% 33.72058 -116.21556      83539  382
## 182                     10.1% 37.38605 -122.08385      77846  424
## 183                      7.4% 37.59339 -122.04383      72528  465
## 184                      3.0% 33.70918 -117.95367      56707  640
## 185                      3.9% 33.66030 -117.99923     197575  117
## 186                      2.4% 33.64113 -117.91867     112174  239
## 187                     15.6% 34.01223 -117.68894      80988  402
## 188                     14.9% 34.21639 -119.03760      66086  523
## 189                     -1.0% 33.96168 -118.35313     111542  242
## 190                           33.95246 -117.58480      55191  660
## 191                    285.2% 38.89156 -121.29301      45237  822
## 192                     10.1% 32.67811 -117.09920      59834  595
## 193                     13.3% 38.10742 -122.56970      54194  676
## 194                     -0.4% 34.06862 -118.02757     115708  234
## 195                     13.7% 37.44188 -122.14302      66642  517
## 196                      0.5% 37.61383 -122.48692      38606  960
## 197                      3.3% 34.09001 -117.89034      48508  774
## 198                      1.3% 34.02112 -118.39647      39428  936
## 199                     42.7% 37.79743 -121.21605      71948  467
## 200                      3.4% 38.01937 -122.13413      37165  992
## 201                     26.8% 34.03363 -117.04309      52536  698
## 202                     12.7% 36.91023 -121.75689      52477  699
## 203                      7.4% 32.79477 -116.96253     102211  282
## 204                      2.0% 33.93029 -118.21146      71371  471
## 205                      3.3% 37.52966 -122.04024      44096  835
## 206                     61.3% 33.68395 -117.79469     236716   85
## 207                      4.2% 33.64697 -117.68922      79312  408
## 208                     13.2% 33.72224 -116.37446      50508  732
## 209                     23.2% 33.78054 -116.46680      52977  693
## 210                      8.3% 34.13973 -118.03534      57639  626
## 211                      5.6% 37.63049 -122.41108      42443  868
## 212                      1.5% 33.77005 -118.19374     469428   36
## 213                      5.3% 33.94011 -118.13316     113242  238
## 214                     13.7% 32.79200 -115.56305      43363  845
## 215                      9.5% 34.09751 -117.64839      75413  442
## 216                     44.0% 32.67895 -115.49888      39389  940
## 217                      5.5% 34.63915 -120.45794      43509  844
## 218                     -2.7% 33.96529 -118.15146      42889  862
## 219                     44.4% 36.96134 -120.06072      63105  554
## 220                     17.4% 37.35411 -121.95524     120245  220
## 221                     -0.7% 33.88946 -118.15979      54980  664
## 222                     70.0% 37.70215 -121.93579      52105  706
## 223                      4.6% 33.64086 -117.60310      49228  758
## 224                     10.8% 34.07390 -117.31365      53243  690
## 225                      2.9% 33.74446 -118.38702      42448  867
## 226                      6.1% 33.86751 -117.99812      82882  386
## 227                      6.3% 33.88168 -118.11701      77593  427
## 228                     33.3% 36.20773 -119.34734      61170  576
## 229                     47.7% 37.99742 -121.71245      38194  966
## 230                      0.0% 38.33964 -122.70110      41398  885
## 231                      3.1% 34.13612 -117.86534      51074  723
## 232                     38.6% 38.67796 -121.17606      73098  458
## 233                      2.8% 33.80252 -117.99312      38623  958
## 234                     37.6% 33.74752 -116.97197      81750  395
## 235                     60.3% 38.79073 -121.23578      59738  597
## 236                     88.4% 33.68030 -116.17389      43092  853
## 237                      4.2% 37.28717 -121.94996      40584  908
## 238                     55.6% 38.58046 -121.53023      49891  746
## 239                      4.6% 33.91724 -118.01201      49133  761
## 240                      8.4% 36.67774 -121.65550     155662  157
## 241                     13.8% 38.67852 -121.77330      56590  643
## 242                      3.3% 33.97918 -118.03284      86635  360
## 243                      8.4% 38.23242 -122.63665      59440  601
## 244                      2.1% 33.85363 -118.13396      81121  399
## 245                      5.3% 33.81696 -118.03729      49087  762
## 246                      3.6% 33.93196 -117.94617      61653  569
## 247                     56.2% 38.75212 -121.28801     127035  206
## 248                     15.2% 33.91668 -117.90006      40963  893
## 249                      6.7% 33.84918 -118.38841      67815  504
## 250                     96.5% 33.66808 -117.32726      57525  628
## 251                    254.5% 33.92946 -116.97725      40481  910
## 252                      0.9% 34.42083 -119.69819      90412  339
## 253                      0.4% 33.98307 -118.09673      63771  547
## 254                     16.6% 38.02798 -121.88468      66695  516
## 255                     26.4% 38.58907 -121.30273      67911  503
## 256                     34.0% 37.59493 -120.95771      46714  797
## 257                     11.8% 33.87224 -117.87034      52206  704
## 258                      0.9% 34.09611 -118.10583      40275  919
## 259                     46.1% 34.42639 -117.30088      92147  327
## 260                     21.0% 34.12834 -117.20865      54291  675
## 261                      3.5% 39.58075 -104.87717     106114  268
## 262                     52.9% 39.86804 -104.97192     127359  205
## 263                      1.9% 39.70471 -105.08137     147214  173
## 264                     96.4% 39.51860 -104.76136      48608  770
## 265                      5.9% 38.25445 -104.60914     108249  259
## 266                     23.1% 40.42331 -104.70913      96539  308
## 267                     37.4% 40.39776 -105.07498      71334  472
## 268                    153.5% 39.37221 -104.85609      53063  692
## 269                    135.4% 39.80832 -104.93387      49799  748
## 270                     26.6% 40.58526 -105.08442     152061  160
## 271                      9.4% 39.61332 -105.01665      44275  832
## 272                      9.4% 39.83665 -105.03720     110945  245
## 273                     21.4% 38.83388 -104.82136     439886   41
## 274                     16.7% 39.73924 -104.99025     649495   22
## 275                     24.4% 40.16721 -105.10193      89919  344
## 276                     24.4% 39.72943 -104.83192     345803   55
## 277                      9.2% 39.80276 -105.08748     111707  241
## 278                     15.5% 39.89618 -104.98115      37499  982
## 279                     30.9% 39.06387 -108.55065      59778  596
## 280                     50.3% 39.92054 -105.08665      59471  600
## 281                      9.0% 40.01499 -105.27055     103166  279
## 282                      5.4% 41.18655  -73.19518     147216  172
## 283                     11.4% 41.39482  -73.45401      83684  380
## 284                      1.9% 41.66121  -72.77954      72939  461
## 285                      3.6% 41.56232  -72.65065      47333  791
## 286                      7.6% 41.05343  -73.53873     126456  209
## 287                      5.5% 41.30827  -72.92788     130660  195
## 288                      1.8% 41.23070  -73.06404      51644  713
## 289                      0.6% 41.76371  -72.68509     125017  212
## 290                      5.1% 41.27055  -72.94697      55046  662
## 291                      5.6% 41.11774  -73.40816      87776  354
## 292                      0.4% 41.67176  -72.94927      60568  583
## 293                      3.7% 41.53815  -72.80704      60456  586
## 294                      7.3% 41.31649  -73.09316      40999  892
## 295                      2.2% 41.55815  -73.05150     109676  253
## 296                     11.6% 41.52426  -72.07591      40347  917
## 297                     -1.6% 39.73907  -75.53979      71525  470
## 298                     16.0% 39.15817  -75.52437      37366  987
## 299                     13.0% 38.90719  -77.03687     646449   23
## 300                      4.2% 26.14036  -80.21338      69813  488
## 301                     21.8% 30.43826  -84.28073     186411  125
## 302                     10.5% 25.94204  -80.24560     111378  243
## 303                      3.6% 25.93315  -80.16255      43250  850
## 304                    137.6% 25.81954  -80.35533      50213  738
## 305                     18.3% 28.03947  -81.94980     100710  289
## 306                     12.9% 26.21286  -80.24977      63155  553
## 307                      0.7% 26.12244  -80.13732     172389  139
## 308                      0.1% 27.96585  -82.80010     109703  252
## 309                      1.4% 27.33643  -82.53065      53326  688
## 310                      2.0% 28.66111  -81.36562      42150  873
## 311                     31.7% 28.03446  -80.58866     104898  270
## 312                     12.8% 29.65163  -82.32483     127488  204
## 313                      7.8% 28.61222  -80.80755      44206  833
## 314                      6.1% 26.46146  -80.07282      64072  543
## 315                     39.6% 26.82339  -80.13865      50699  728
## 316                     28.4% 26.25175  -80.17894      56792  636
## 317                      5.9% 27.84280  -82.69954      49998  744
## 318                     86.2% 28.24890  -81.28118      40918  898
## 319                     22.8% 29.13832  -80.99561      57203  631
## 320                      3.4% 27.49893  -82.57482      51763  711
## 321                    142.5% 28.56528  -81.58618      37711  975
## 322                     23.1% 28.90054  -81.26367      86290  363
## 323                     34.5% 26.10037  -80.39977      68388  497
## 324                      5.1% 27.90947  -82.78732      78409  418
## 325                     16.1% 25.72149  -80.26838      49631  752
## 326                     14.9% 25.76168  -80.19179     417650   44
## 327                    100.7% 25.46872  -80.47756      64079  542
## 328                     74.7% 25.98608  -80.30356     130288  196
## 329                    154.6% 27.04422  -82.23593      59212  606
## 330                      6.9% 27.44671  -80.32561      43074  854
## 331                     32.6% 28.29196  -81.40757      65173  534
## 332                     -6.0% 30.42131  -87.21691      52703  696
## 333                    137.2% 29.58445  -81.20787      78740  415
## 334                     14.3% 30.33218  -81.65565     842583   13
## 335                      3.3% 25.79065  -80.13005      91026  336
## 336                     23.5% 26.71534  -80.05337     102436  280
## 337                     17.4% 26.00776  -80.29626     162329  150
## 338                     46.2% 26.93422  -80.09421      58298  619
## 339                      8.6% 26.12759  -80.23310      90268  340
## 340                      5.8% 29.28581  -81.05589      38661  956
## 341                      4.0% 26.23786  -80.12477     104410  276
## 342                      2.7% 26.24453  -80.20644      55456  656
## 343                     57.9% 28.56917  -81.54396      39172  947
## 344                     31.2% 28.53834  -81.37924     255483   77
## 345                      3.2% 25.85760  -80.27811     233394   89
## 346                     63.9% 28.69341  -81.53221      45587  815
## 347                     17.7% 26.07648  -80.25212      96830  307
## 348                      5.9% 28.08363  -80.60811      77508  428
## 349                      2.7% 26.17231  -80.13199      43286  849
## 350                      4.8% 26.01120  -80.14949     146526  174
## 351                      0.1% 30.15881  -85.66021      36877 1000
## 352                     12.4% 25.98120  -80.14838      38632  957
## 353                      5.7% 26.27119  -80.27060     126604  208
## 354                      4.6% 26.16697  -80.25659      90116  342
## 355                      0.3% 27.77306  -82.64000     249688   78
## 356                     17.3% 26.53179  -80.09055      71097  474
## 357                     16.0% 27.95058  -82.45718     352957   53
## 358                     -2.3% 29.21081  -81.02283      62316  559
## 359                     31.2% 26.64063  -81.87231      68190  501
## 360                     60.4% 26.56285  -81.94953     165831  146
## 361                     43.8% 26.33981  -81.77870      47547  787
## 362                      2.0% 25.89009  -80.18671      61007  580
## 363                      7.5% 26.36831  -80.12893      89407  345
## 364                     10.8% 26.21730  -80.22588      42757  864
## 365                     42.8% 28.80286  -81.26945      56002  650
## 366                     35.5% 26.62763  -80.13539      38696  955
## 367                     91.7% 27.27305  -80.35823     171016  142
## 368                     47.2% 25.95648  -80.13921      37199  991
## 369                      4.8% 26.31841  -80.09977      78041  422
## 370                     42.9% 25.58083  -80.34686      43328  848
## 371                     20.8% 29.18720  -82.14009      57468  629
## 372                     55.0% 26.66176  -80.26836      60202  588
## 373                      6.2% 33.74900  -84.38798     447841   40
## 374                     -3.8% 33.95260  -84.54993      59089  608
## 375                     15.2% 34.02324  -84.36156      94034  318
## 376                     20.0% 33.88399  -84.51438      53438  687
## 377                           33.96989  -84.22146      40059  923
## 378                     17.4% 33.93044  -84.37331      99770  295
## 379                     36.5% 34.02893  -84.19858      82788  389
## 380                     19.0% 33.95193  -83.35757     119980  222
## 381                      8.7% 32.46098  -84.98771     202824  110
## 382                           33.94621  -84.33465      47591  784
## 383                      1.1% 33.47350  -82.01051     197350  119
## 384                     22.3% 30.83270  -83.27849      56481  645
## 385                     -0.6% 31.57851  -84.15574      76185  436
## 386                     45.7% 32.61300  -83.62420      72531  464
## 387                     -7.3% 32.84069  -83.63240      89981  343
## 388                           33.86510  -84.33659      50603  729
## 389                      7.5% 32.08354  -81.09983     142772  180
## 390                     33.6% 34.07538  -84.29409      62298  560
## 391                     -6.2% 21.30694 -157.85833     347884   54
## 392                     14.0% 43.49165 -112.03396      58292  620
## 393                     31.5% 42.56297 -114.46087      45981  808
## 394                      5.4% 42.87130 -112.44553      54350  674
## 395                     77.1% 43.66294 -116.68736      48957  763
## 396                    127.6% 43.61211 -116.39151      83596  381
## 397                     32.8% 47.67768 -116.78047      46402  801
## 398                     57.9% 43.54072 -116.56346      86518  361
## 399                      9.5% 43.61871 -116.21461     214237   98
## 400                     -0.2% 41.91253  -88.13479      40379  914
## 401                     16.0% 42.03541  -88.28257     110145  249
## 402                     -1.0% 42.27113  -89.09400     150251  164
## 403                     -1.6% 41.84559  -87.75394      84103  377
## 404                     10.1% 42.02558  -88.17841      40351  916
## 405                      0.5% 39.93560  -91.40987      40915  899
## 406                      0.1% 42.01114  -87.84062      37839  972
## 407                      2.8% 42.03240  -87.74162      65176  533
## 408                     13.1% 41.99503  -88.18563      41679  881
## 409                     -1.9% 41.50670  -90.51513      43116  852
## 410                     11.8% 41.92947  -88.75036      43849  840
## 411                      3.3% 41.71998  -87.74795      57073  633
## 412                     29.7% 41.69864  -88.06840      73936  454
## 413                     36.5% 41.52503  -88.08173     147806  169
## 414                     19.7% 40.51420  -88.99063      54664  671
## 415                      0.5% 42.36363  -87.84479      88826  348
## 416                     22.8% 42.12114  -88.25786      38241  965
## 417                      5.3% 42.24113  -88.31620      40388  912
## 418                     -3.4% 42.16628  -87.96313      41778  875
## 419                     12.0% 41.75084  -88.15354     144864  176
## 420                      2.9% 41.88003  -88.00784      43907  838
## 421                      3.0% 40.69365  -89.58899     116513  232
## 422                     -0.6% 42.08836  -87.98063      75994  437
## 423                     13.9% 41.63031  -87.85394      58590  614
## 424                      5.7% 41.89947  -87.94034      45556  816
## 425                      0.6% 41.99947  -88.14507      38510  961
## 426                     18.3% 40.11642  -88.24338      83424  385
## 427                     16.3% 41.57314  -87.79329      57282  630
## 428                      0.0% 41.80892  -88.01117      49670  751
## 429                     -2.5% 42.06642  -87.93729      54771  669
## 430                      5.2% 42.06975  -87.78784      45417  819
## 431                     38.4% 41.76058  -88.32007     199963  114
## 432                     -0.5% 42.03336  -88.08341      74907  445
## 433                     79.5% 41.64753  -88.08951      39650  931
## 434                     -6.1% 41.87811  -87.62980    2718782    3
## 435                    203.6% 41.63222  -88.21203      41734  879
## 436                      5.1% 41.85059  -87.79367      56758  638
## 437                      3.2% 42.03336  -87.88340      58918  611
## 438                     -8.7% 39.84031  -88.95480      74710  448
## 439                     10.3% 40.11059  -88.20727      41752  878
## 440                     -0.8% 41.88503  -87.78450      52066  707
## 441                     -1.9% 41.50948  -90.57875      38877  951
## 442                     -3.4% 41.86614  -88.10701      53648  686
## 443                      4.5% 42.11030  -88.03424      69350  490
## 444                      4.2% 39.78172  -89.65015     117006  230
## 445                      2.6% 41.93170  -87.98896      37385  986
## 446                      1.2% 38.52005  -89.98399      42895  861
## 447                     -4.5% 41.61559  -87.52949      37240  989
## 448                      4.8% 42.13919  -87.92896      38015  970
## 449                     20.1% 40.48420  -88.99369      78902  412
## 450                      1.9% 42.04507  -87.68770      75570  439
## 451                      5.4% 42.06299  -88.12272      52398  702
## 452                    -23.4% 41.59337  -87.34643      78450  417
## 453                      2.5% 39.46670  -87.41391      61025  579
## 454                      7.8% 39.76840  -86.15807     843393   12
## 455                     16.1% 39.16533  -86.52639      82575  392
## 456                     14.5% 40.41670  -86.87529      70373  481
## 457                     88.1% 40.04559  -86.00860      56540  644
## 458                      2.0% 41.66199  -86.15862      47989  778
## 459                     -0.7% 40.19338  -85.38636      70316  483
## 460                     60.4% 39.97837  -86.11804      85927  366
## 461                     16.4% 39.20144  -85.92138      45775  813
## 462                     21.3% 40.48643  -86.13360      56895  635
## 463                     -4.6% 41.58337  -87.50004      78967  410
## 464                     -6.6% 40.10532  -85.68025      55670  655
## 465                     46.0% 39.61366  -86.10665      53665  684
## 466                     20.5% 39.83865  -86.02526      47135  794
## 467                     -2.5% 41.68199  -85.97667      51265  721
## 468                     -0.8% 37.97156  -87.57109     120310  219
## 469                     53.3% 38.27757  -85.73718      45929  809
## 470                    114.8% 39.95675  -86.01335      83891  378
## 471                     -6.8% 41.67635  -86.25199     100886  288
## 472                      1.0% 41.07927  -85.13935     256496   76
## 473                     13.8% 41.66113  -91.53017      71591  468
## 474                      5.4% 41.97788  -91.66562     128429  199
## 475                      3.9% 41.52364  -90.57764     102157  283
## 476                     -2.9% 42.49999  -96.40031      82459  393
## 477                     21.3% 42.03472  -93.62000      61792  568
## 478                      0.9% 42.50056  -90.66457      58253  621
## 479                     86.9% 41.73179  -93.60013      51567  715
## 480                     29.8% 41.57721  -93.71133      61255  574
## 481                      6.2% 41.26194  -95.86083      61969  565
## 482                      3.9% 41.60054  -93.60911     207510  104
## 483                     41.5% 41.62666  -93.71217      41776  876
## 484                     12.0% 42.53490  -92.44532      40566  909
## 485                     -0.5% 42.49279  -92.34258      68366  498
## 486                     19.4% 38.98223  -94.67079     181260  132
## 487                      9.7% 37.68889  -97.33611     386552   49
## 488                      4.5% 38.84028  -97.61142      47846  779
## 489                     24.6% 38.95362  -94.73357      50344  735
## 490                      3.4% 39.05582  -95.68902     127679  202
## 491                      1.1% 39.11405  -94.62746     148483  168
## 492                      0.1% 38.06084  -97.92977      41889  874
## 493                     40.4% 38.88140  -94.81913     131885  193
## 494                     12.7% 38.97167  -95.23525      90811  338
## 495                     22.8% 39.18361  -96.57167      56143  647
## 496                     32.2% 39.02285  -94.71519      64323  541
## 497                      7.7% 37.77191  -87.11117      58416  617
## 498                     18.0% 38.04058  -84.50372     308428   61
## 499                     24.1% 36.96852  -86.48080      61488  571
## 500                     10.0% 38.25266  -85.75846     609893   28
## 501                     -4.7% 39.08367  -84.50855      40956  894
## 502                     17.4% 32.51599  -93.73212      66333  518
## 503                      4.1% 31.31129  -92.44514      48426  775
## 504                     -4.8% 29.99409  -90.24174      66975  512
## 505                     -0.1% 32.52515  -93.75018     200327  113
## 506                    -21.6% 29.95107  -90.07153     378715   51
## 507                      3.0% 30.22659  -93.21738      74024  452
## 508                     -6.1% 32.50931  -92.11930      49761  749
## 509                      0.4% 30.45828  -91.14032     229426   93
## 510                     11.0% 30.22409  -92.01984     124276  214
## 511                      3.2% 43.66147  -70.25533      66318  519
## 512                     34.0% 39.08400  -77.15276      64072  544
## 513                      8.6% 39.00678  -76.77914      56759  637
## 514                     25.9% 39.41427  -77.41054      66893  514
## 515                     -4.0% 39.29038  -76.61219     622104   26
## 516                     24.2% 39.14344  -77.20137      65690  526
## 517                     10.4% 39.64176  -77.71999      40612  906
## 518                      7.6% 38.97845  -76.49218      38722  954
## 519                      3.0% 42.12509  -72.74954      41301  887
## 520                      2.7% 42.41843  -71.10616      57170  632
## 521                     12.1% 42.40843  -71.05366      42935  858
## 522                      7.5% 42.70704  -71.16311      77657  426
## 523                      1.2% 41.63622  -70.93420      95078  315
## 524                      4.9% 42.33704  -71.20922      87971  351
## 525                     -7.1% 41.70032  -70.30020      44641  827
## 526                      7.5% 42.52787  -70.92866      52044  708
## 527                      2.6% 42.46676  -70.94949      91589  333
## 528                      5.8% 42.25288  -71.00227      93494  320
## 529                     -1.1% 42.52509  -71.75979      41002  891
## 530                           42.21807  -70.94104      55419  657
## 531                      3.5% 42.58342  -71.80230      40383  913
## 532                      3.4% 42.63342  -71.31617     108861  257
## 533                      7.6% 42.34593  -71.55229      39414  937
## 534                      0.9% 42.20426  -72.61620      40249  920
## 535                      4.6% 41.94454  -71.28561      43886  839
## 536                      1.7% 42.14870  -72.60787      55717  654
## 537                      0.0% 41.90010  -71.08977      56069  649
## 538                     -0.3% 42.08343  -71.01838      94089  317
## 539                      5.0% 42.77620  -71.07728      62088  564
## 540                      5.0% 42.37649  -71.23561      62227  562
## 541                      5.5% 42.37362  -71.10973     107289  264
## 542                      4.4% 42.47926  -71.15228      39083  949
## 543                     -3.6% 42.45008  -73.24538      44057  836
## 544                      2.0% 42.55843  -70.88005      40664  904
## 545                      9.4% 42.36008  -71.05888     645966   24
## 546                      5.8% 42.26259  -71.80229     182544  129
## 547                     10.3% 42.72620  -71.19089      48514  773
## 548                      1.6% 42.38760  -71.09950      78804  414
## 549                     13.4% 42.40843  -71.01199      53756  682
## 550                     -3.7% 41.70149  -71.15505      88697  349
## 551                      7.4% 42.42510  -71.06616      60509  585
## 552                      7.3% 42.39176  -71.03283      37670  976
## 553                      1.1% 42.10148  -72.58981     153703  158
## 554                      5.1% 42.51954  -70.89672      42544  866
## 555                     -5.4% 42.36837  -83.35271      95208  314
## 556                     -2.8% 42.32115  -85.17971      51848  710
## 557                     -3.0% 42.33698  -83.27326      56620  642
## 558                     -1.0% 42.49726  -82.93714      47555  786
## 559                     -1.7% 42.48948  -83.14465      58946  610
## 560                     -6.7% 42.47337  -83.22187      73006  459
## 561                     -4.7% 42.32420  -83.40021      82578  391
## 562                     10.5% 42.86947  -85.64475      50233  737
## 563                      0.9% 43.61558  -84.24721      42181  872
## 564                      4.2% 42.73698  -84.48387      48554  772
## 565                      5.7% 42.20115  -85.58000      47523  788
## 566                     -2.0% 42.32226  -83.17631      95884  311
## 567                      5.7% 42.65837  -83.14993      72952  460
## 568                    -11.4% 42.63892  -83.29105      59887  594
## 569                     -6.3% 42.24087  -83.26965      61817  566
## 570                    -20.0% 43.01253  -83.68746      99763  297
## 571                     -4.4% 42.73253  -84.55553     113972  236
## 572                     -2.8% 42.96336  -85.66809     192294  123
## 573                     -7.1% 43.23418  -86.24839      37213  990
## 574                     -0.9% 42.49899  -83.36772      81295  397
## 575                     -6.7% 42.25059  -83.17854      37313  988
## 576                     -4.6% 42.49741  -82.89636      60070  592
## 577                      2.2% 42.60641  -83.14978      82821  387
## 578                     -2.3% 42.51446  -83.01465     134873  189
## 579                    -18.2% 43.41947  -83.95081      50303  736
## 580                     22.0% 42.48059  -83.47549      57960  624
## 581                      2.0% 42.28083  -83.74304     117025  229
## 582                      5.2% 42.58031  -83.03020     131224  194
## 583                    -27.1% 42.33143  -83.04575     688701   18
## 584                      6.5% 42.91336  -85.70531      74100  451
## 585                     -1.9% 42.29171  -85.58723      75548  440
## 586                      1.3% 44.84080  -93.29828      86319  362
## 587                      9.2% 44.73191  -93.21772      50201  739
## 588                     16.0% 45.09413  -93.35634      78373  419
## 589                     21.3% 46.87376  -96.76780      39398  939
## 590                     23.9% 44.01212  -92.48020     110742  246
## 591                     39.8% 44.92386  -92.95938      65656  528
## 592                      0.6% 45.17324  -93.30301      62103  563
## 593                     12.0% 45.01052  -93.45551      73987  453
## 594                      2.6% 44.80413  -93.16689      65453  529
## 595                     34.3% 44.64969  -93.24272      58562  616
## 596                      2.8% 44.95370  -93.08996     294873   66
## 597                      7.3% 44.95974  -93.37022      47411  789
## 598                     27.3% 45.07246  -93.45579      65415  531
## 599                     -0.1% 46.78667  -92.10049      86128  365
## 600                     12.3% 44.95302  -92.99522      39765  930
## 601                     85.7% 44.79740  -93.52729      39167  948
## 602                     24.7% 44.16358  -93.99940      40641  905
## 603                     10.9% 45.55795  -94.16324      66297  520
## 604                     32.8% 45.16080  -93.23495      60407  587
## 605                      4.1% 44.88969  -93.34995      49376  756
## 606                      4.5% 44.97775  -93.26501     400070   46
## 607                      0.4% 44.92118  -93.46875      51368  720
## 608                     13.3% 44.85469  -93.47079      62603  557
## 609                      1.9% 44.76774  -93.27772      61434  572
## 610                     72.8% 34.98898  -90.01259      50997  724
## 611                     -6.8% 32.29876  -90.18481     172638  138
## 612                     -0.9% 32.36431  -88.70366      40921  896
## 613                      3.1% 31.32712  -89.29034      47556  785
## 614                     -0.6% 30.36742  -89.09282      71012  476
## 615                    -11.5% 30.39603  -88.88531      44820  825
## 616                      6.7% 38.57670  -92.17352      43330  847
## 617                      7.8% 37.20896  -93.29230     164122  148
## 618                      3.2% 39.09112  -94.41551     117240  227
## 619                     31.2% 38.91084  -94.38217      93184  323
## 620                     11.2% 37.08423  -94.51328      50789  726
## 621                      1.9% 38.66311  -90.57707      47749  782
## 622                      9.9% 39.01695  -94.28161      53294  689
## 623                     11.3% 38.78811  -90.49744      67569  507
## 624                      9.4% 37.30588  -89.51815      38816  953
## 625                     -8.2% 38.62700  -90.19940     318416   58
## 626                      5.5% 39.09973  -94.57857     467007   37
## 627                     -2.8% 38.78922  -90.32261      52363  703
## 628                     34.0% 38.95171  -92.33407     115276  235
## 629                      4.1% 39.76746  -94.84668      77147  429
## 630                     62.6% 38.81061  -90.69985      82809  388
## 631                      6.5% 38.78747  -90.62989      54842  667
## 632                     18.6% 45.78329 -108.50069     109059  256
## 633                      3.9% 47.49418 -111.28334      59351  604
## 634                     19.7% 46.87872 -113.99659      69122  491
## 635                     41.9% 45.67700 -111.04293      39860  925
## 636                     20.5% 41.15436  -95.91456      53663  685
## 637                     16.0% 40.92640  -98.34201      50550  731
## 638                     18.0% 40.82576  -96.68520     268738   72
## 639                      5.9% 41.25236  -95.99799     434353   42
## 640                     26.8% 39.52963 -119.81380     233294   90
## 641                     24.5% 36.16994 -115.13983     603488   30
## 642                      2.9% 39.16380 -119.76740      54080  678
## 643                     51.0% 36.03952 -114.98172     270811   71
## 644                     92.2% 36.19886 -115.11750     226877   96
## 645                     39.4% 39.53491 -119.75269      93282  321
## 646                      4.1% 43.20814  -71.53757      42419  869
## 647                      2.9% 42.99564  -71.45479     110378  248
## 648                      0.4% 42.76537  -71.46757      87137  358
## 649                     -1.2% 40.21705  -74.74294      84349  374
## 650                     13.3% 40.78788  -74.01431      52122  705
## 651                      7.9% 40.85843  -74.16376      85390  368
## 652                      9.6% 40.45940  -74.36085      44412  829
## 653                     35.8% 40.74399  -74.03236      52575  697
## 654                      5.5% 40.66399  -74.21070     127558  203
## 655                      9.3% 39.48638  -75.02596      61050  578
## 656                      9.7% 40.50677  -74.26542      51982  709
## 657                      4.3% 40.85677  -74.12848      70868  478
## 658                      2.8% 40.76843  -74.14542      41664  882
## 659                     -3.6% 39.92595  -75.11962      76903  430
## 660                      2.1% 40.73566  -74.17237     278427   69
## 661                      7.2% 40.72816  -74.07764     257342   74
## 662                      5.7% 40.63371  -74.40737      50588  730
## 663                      5.1% 40.66871  -74.11431      65028  538
## 664                      4.7% 40.62205  -74.24459      41301  886
## 665                     -2.2% 39.36428  -74.42293      39551  933
## 666                      2.9% 40.88593  -74.04347      44113  834
## 667                     -7.4% 40.76732  -74.20487      64544  540
## 668                     15.5% 40.48622  -74.45182      55831  652
## 669                      1.7% 40.69759  -74.26316      68247  499
## 670                     -2.2% 40.91677  -74.17181     145948  175
## 671                     37.6% 32.31994 -106.76365     101324  285
## 672                     18.1% 36.72806 -108.21869      45426  818
## 673                     10.5% 35.68698 -105.93780      69976  487
## 674                     21.3% 34.40480 -103.20523      39508  934
## 675                     23.5% 35.08533 -106.60555     556495   32
## 676                      7.5% 33.39427 -104.52302      48611  769
## 677                     74.4% 35.23275 -106.66304      91956  329
## 678                     -1.4% 40.65760  -73.58318      43167  851
## 679                     -4.1% 43.16103  -77.61092     210358  103
## 680                      1.5% 42.72841  -73.69179      49974  745
## 681                    -11.3% 42.88645  -78.87837     258959   73
## 682                      4.1% 42.65258  -73.75623      98424  299
## 683                      6.7% 42.81424  -73.93957      65902  525
## 684                      1.8% 40.93121  -73.89875     199766  115
## 685                      8.5% 41.03399  -73.76291      57866  625
## 686                    -10.8% 43.09621  -79.03774      49468  754
## 687                     -1.7% 42.09869  -75.91797      46444  800
## 688                      3.6% 40.66427  -73.70846      37659  977
## 689                      2.2% 43.10090  -75.23266      61808  567
## 690                     -0.9% 43.04812  -76.14742     144669  177
## 691                      9.9% 40.91149  -73.78235      79446  407
## 692                     -0.2% 40.91260  -73.83708      68224  500
## 693                      4.8% 40.71278  -74.00594    8405837    1
## 694                      4.0% 40.70621  -73.61874      55361  658
## 695                     24.8% 34.22573  -77.94471     112067  240
## 696                     10.1% 35.72127  -77.91554      49628  753
## 697                      7.0% 35.73445  -81.34446      40361  915
## 698                     22.3% 36.07264  -79.79198     279639   68
## 699                     98.8% 35.73265  -78.85029      42214  871
## 700                      5.0% 34.75405  -77.43024      69079  493
## 701                     24.3% 35.95569  -80.00532     107741  260
## 702                     92.9% 35.41069  -80.84285      50458  733
## 703                     41.9% 35.61266  -77.36635      89130  347
## 704                      2.4% 35.05266  -78.87836     204408  106
## 705                     24.1% 35.91320  -79.05584      59635  598
## 706                     55.1% 35.79154  -78.78112     151088  163
## 707                     19.6% 35.59506  -82.55149      87236  357
## 708                     16.9% 36.09986  -80.24422     236441   86
## 709                     39.1% 35.22709  -80.84313     792862   16
## 710                     12.1% 36.09569  -79.43780      51510  717
## 711                     47.4% 35.40875  -80.57951      83506  383
## 712                     29.9% 35.99403  -78.89862     245475   82
## 713                     18.6% 35.48736  -80.62173      44359  830
## 714                     48.7% 35.77959  -78.63818     431746   43
## 715                     -3.1% 35.93821  -77.79053      56954  634
## 716                      8.2% 35.26208  -81.18730      73209  457
## 717                     20.1% 46.80833 -100.78374      67034  510
## 718                     24.9% 46.87719  -96.78980     113658  237
## 719                     26.6% 48.23297 -101.29229      46321  803
## 720                     11.5% 47.92526  -97.03285      54932  665
## 721                     -8.4% 41.59310  -81.52679      48139  777
## 722                    -10.1% 39.10312  -84.51202     297517   65
## 723                     -0.2% 39.84395  -84.12466      38142  967
## 724                     -7.2% 41.45282  -82.18237      63710  548
## 725                     19.0% 39.70923  -84.06327      45712  814
## 726                    -10.3% 40.79895  -81.37845      72535  463
## 727                     -3.7% 41.36838  -82.10765      53956  681
## 728                    -18.1% 41.49932  -81.69436     390113   48
## 729                      5.8% 41.04422  -83.64993      41512  884
## 730                     35.6% 39.88145  -83.09296      37490  984
## 731                      5.7% 40.12617  -82.92907      37530  981
## 732                    -10.0% 41.66394  -83.55521     282313   67
## 733                     -3.1% 39.68950  -84.16883      55870  651
## 734                     -8.6% 41.08144  -81.51901     198100  116
## 735                      1.2% 39.34547  -84.56032      42635  865
## 736                      1.9% 41.31450  -81.83569      44730  826
## 737                      2.7% 39.39950  -84.56134      62258  561
## 738                     -9.8% 39.92423  -83.80882      59357  603
## 739                     -9.4% 41.48199  -81.79819      51143  722
## 740                     -8.1% 40.74255  -84.10523      38355  963
## 741                     10.7% 39.71368  -82.59933      39325  944
## 742                    -10.1% 40.75839  -82.51545      46454  799
## 743                    -20.2% 41.09978  -80.64952      65184  532
## 744                     14.8% 39.96118  -82.99879     822553   15
## 745                     37.6% 40.09923  -83.11408      43607  842
## 746                     -6.6% 41.66616  -81.33955      46979  796
## 747                     -0.2% 41.13394  -81.48456      49267  757
## 748                    -15.2% 41.23756  -80.81842      40768  901
## 749                    -10.3% 41.52005  -81.55624      45394  820
## 750                    -13.5% 39.75895  -84.19161     143355  179
## 751                     -5.9% 41.40477  -81.72291      80429  406
## 752                      3.1% 40.05812  -82.40126      47777  781
## 753                     -5.7% 39.51506  -84.39828      48630  767
## 754                     -0.7% 35.74788  -95.36969      38863  952
## 755                      1.3% 36.15398  -95.99278     398121   47
## 756                     20.2% 35.46756  -97.51643     610613   27
## 757                      4.5% 35.44951  -97.39670      56756  639
## 758                     26.9% 35.65283  -97.47810      87004  359
## 759                     22.0% 35.22257  -97.43948     118197  225
## 760                     28.2% 36.06095  -95.79745     103500  278
## 761                      8.1% 36.39559  -97.87839      50725  727
## 762                     20.1% 36.11561  -97.05837      47186  792
## 763                      4.9% 34.60357  -98.39593      97151  304
## 764                     41.5% 35.33951  -97.48670      58414  618
## 765                     17.8% 45.43123 -122.77149      50444  734
## 766                     11.8% 44.56457 -123.26204      55298  659
## 767                     14.4% 44.99012 -123.02621      37064  997
## 768                     20.7% 45.50014 -122.43020     109397  254
## 769                     36.4% 45.52289 -122.98983      97368  303
## 770                     25.5% 44.63651 -123.10593      51583  714
## 771                     17.0% 45.48706 -122.80371      93542  319
## 772                     15.0% 45.52306 -122.67648     609456   29
## 773                     12.4% 44.04624 -123.02203      60177  590
## 774                     14.4% 44.05207 -123.08675     159190  155
## 775                     17.1% 42.32652 -122.87559      77677  425
## 776                     54.3% 44.05817 -121.31531      81236  398
## 777                     16.4% 44.94290 -123.03510     160614  152
## 778                      5.3% 45.42067 -122.67065      37610  979
## 779                     -4.3% 41.24591  -75.88131      41108  889
## 780                      8.7% 40.79339  -77.86000      41757  877
## 781                      2.6% 39.95258  -75.16522    1553165    5
## 782                      4.5% 40.03788  -76.30551      59325  605
## 783                      6.4% 39.96260  -76.72774      43935  837
## 784                      0.0% 41.40897  -75.66241      75806  438
## 785                      0.6% 40.27319  -76.88670      49188  759
## 786                     -7.3% 40.51868  -78.39474      45796  812
## 787                      5.2% 40.62593  -75.37046      75018  444
## 788                      8.0% 40.33565  -75.92687      87893  353
## 789                     -2.8% 42.12922  -80.08506     100671  290
## 790                     -8.3% 40.44062  -79.99589     305841   62
## 791                     11.2% 40.60843  -75.49018     118577  224
## 792                      1.4% 41.77982  -71.43728      80566  405
## 793                     -4.6% 41.70010  -71.41617      81971  394
## 794                     -3.3% 41.81371  -71.37005      47149  793
## 795                      2.3% 41.82399  -71.41283     177994  134
## 796                     -5.2% 42.00288  -71.51478      41026  890
## 797                     -2.5% 41.87871  -71.38256      71172  473
## 798                      8.2% 34.85262  -82.39401      61397  573
## 799                     11.7% 34.00071  -81.03481     133358  192
## 800                     29.2% 32.77647  -79.93105     127999  200
## 801                      1.3% 33.92044  -80.34147      41190  888
## 802                     62.9% 33.01850  -80.17565      46074  807
## 803                     -6.2% 34.94957  -81.93205      37647  978
## 804                     53.2% 32.83232  -79.82843      74885  446
## 805                     16.0% 32.21632  -80.75261      39412  938
## 806                     36.0% 34.92487  -81.02508      69103  492
## 807                     26.1% 32.98101  -80.03259      39823  927
## 808                     27.4% 32.85462  -79.97481     104054  277
## 809                     19.8% 34.19543  -79.76256      37792  973
## 810                     31.1% 43.54460  -96.73110     164676  147
## 811                     17.9% 44.08054 -103.23101      70812  479
## 812                     65.1% 35.84562  -86.39027     117044  228
## 813                     16.7% 36.54843  -82.56182      52962  694
## 814                     16.2% 36.16266  -86.78160     634464   25
## 815                      3.9% 35.96064  -83.92074     183270  128
## 816                      4.1% 35.08676  -89.81009      39375  942
## 817                     31.7% 35.20453  -89.87398      58226  622
## 818                     16.2% 36.31344  -82.35347      65123  535
## 819                     43.4% 35.04204  -89.66453      47333  790
## 820                     12.9% 35.61452  -88.81395      67685  505
## 821                     -5.3% 35.14953  -90.04898     653450   20
## 822                     54.9% 35.98284  -86.51860      43060  855
## 823                     36.9% 36.52977  -87.35945     142357  181
## 824                     31.7% 36.30477  -86.62000      54068  680
## 825                     14.1% 35.15952  -84.87661      42774  863
## 826                     51.9% 36.03312  -86.78278      40021  924
## 827                     48.5% 35.92506  -86.86889      68886  494
## 828                     10.5% 35.04563  -85.30968     173366  136
## 829                     13.2% 32.94833  -96.72985     104475  275
## 830                     14.9% 32.97564  -96.88996     126700  207
## 831                     -6.0% 29.88495  -93.93995      54135  677
## 832                     13.2% 30.72353  -95.55078      39795  928
## 833                     14.1% 27.80058  -97.39638     316381   60
## 834                     64.0% 29.70300  -98.12445      63279  551
## 835                     31.7% 30.26715  -97.74306     885400   11
## 836                     28.9% 33.04623  -96.99417     101074  287
## 837                     98.3% 29.50745  -95.09493      90983  337
## 838                     10.3% 32.95457  -97.01501      40342  918
## 839                     11.6% 33.63566  -96.60888      39296  946
## 840                    117.2% 29.56357  -95.28605     100065  292
## 841                     45.1% 32.75549  -97.33077     792727   17
## 842                     32.5% 33.01457  -97.09696      68609  496
## 843                     28.6% 29.52940  -95.20104      37587  980
## 844                     20.2% 32.83430  -97.22890      67317  509
## 845                     13.3% 32.73569  -97.10807     379577   50
## 846                     10.3% 29.38385  -94.90270      46081  806
## 847                     27.1% 31.09823  -97.34278      70190  484
## 848                     61.9% 30.31188  -95.45605      63032  555
## 849                    -15.2% 29.30135  -94.79770      48733  765
## 850                      0.7% 33.91371  -98.49339     104898  271
## 851                     11.0% 29.76043  -95.36980    2195914    4
## 852                    104.0% 33.10317  -96.67055      92020  328
## 853                     19.6% 33.57786 -101.85517     239538   84
## 854                     91.9% 30.63326  -97.67798      54898  666
## 855                     26.8% 25.90175  -97.49748     181860  131
## 856                    134.3% 30.50520  -97.82029      61238  575
## 857                     43.1% 32.74596  -96.99778     183372  127
## 858                     55.7% 26.19480  -98.18362      73790  455
## 859                    287.7% 33.15067  -96.82361     136791  186
## 860                     19.1% 32.81402  -96.94889     228653   94
## 861                     38.2% 27.53057  -99.48032     248142   80
## 862                     14.7% 32.76680  -96.59916     143484  178
## 863                     11.6% 26.19063  -97.69610      65665  527
## 864                    114.2% 32.56319  -97.14168      60872  581
## 865                      7.4% 33.42513  -94.04769      37442  985
## 866                     10.2% 31.46377 -100.43704      97492  302
## 867                      5.8% 32.82346  -97.17057      38448  962
## 868                     81.0% 30.50826  -97.67890     109821  251
## 869                     18.6% 32.35126  -95.30106     100223  291
## 870                      7.5% 28.80527  -97.00360      65098  536
## 871                      3.7% 30.08017  -94.12656     117796  226
## 872                    123.4% 30.43937  -97.62000      53752  683
## 873                     27.6% 26.20341  -98.23001     136639  188
## 874                     19.3% 30.67436  -96.36996      78709  416
## 875                     85.3% 32.54208  -97.32085      40714  903
## 876                     29.1% 29.61968  -95.63495      83860  379
## 877                     47.1% 33.21484  -97.13307     123099  217
## 878                     28.8% 26.15952  -97.99084      37093  996
## 879                     11.6% 32.50070  -94.74049      81443  396
## 880                    165.3% 33.19725  -96.63978     148559  167
## 881                      5.6% 32.77666  -96.79699    1257676    9
## 882                    117.2% 32.93123  -96.45971      40922  895
## 883                      7.5% 29.69106  -95.20910     152735  159
## 884                     74.5% 26.21591  -98.32529      81050  401
## 885                     45.2% 30.62798  -96.33441     100050  293
## 886                     12.8% 35.22200 -101.83130     196429  120
## 887                    185.2% 33.01512  -96.53888      44575  828
## 888                     65.1% 26.30174  -98.16334      80836  404
## 889                     31.1% 29.61857  -95.53772      70185  485
## 890                     22.4% 33.01984  -96.69889     274409   70
## 891                     48.5% 29.88327  -97.94139      54076  679
## 892                      2.9% 32.84402  -97.14307      48592  771
## 893                      3.6% 32.44874  -99.73314     120099  221
## 894                     19.4% 31.77758 -106.44246     674433   19
## 895                     13.1% 29.73550  -94.97743      75418  441
## 896                     45.7% 33.08061  -96.89283      39458  935
## 897                     11.4% 32.79957  -97.26918      43580  843
## 898                     52.1% 31.11712  -97.72780     137147  185
## 899                     46.4% 32.59208  -96.75611      38071  968
## 900                      8.5% 32.91262  -96.63888     234566   88
## 901                     30.4% 31.99735 -102.07791     123933  215
## 902                     17.6% 32.93429  -97.07807      50195  740
## 903                      9.7% 32.65180  -96.90834      39605  932
## 904                     15.1% 32.83707  -97.08195      53224  691
## 905                     36.0% 32.58970  -96.85707      51483  718
## 906                     42.4% 32.58847  -96.95612      46663  798
## 907                     12.5% 31.54933  -97.14667     129030  197
## 908                     28.6% 32.90290  -96.56388      58043  623
## 909                     21.0% 29.42412  -98.49363    1409019    7
## 910                     53.3% 32.93419  -97.22930      42907  860
## 911                     22.3% 31.84568 -102.36764     110720  247
## 912                    176.3% 40.39162 -111.85077      54382  673
## 913                     78.1% 40.11496 -111.65492      36956  998
## 914                      1.3% 40.56498 -111.83897      90231  341
## 915                     53.1% 37.09653 -113.56842      76817  431
## 916                    100.1% 40.56217 -111.92966      59366  602
## 917                      8.5% 40.29690 -111.69465      91648  332
## 918                     22.2% 40.69161 -112.00105     133579  191
## 919                     10.0% 40.23384 -111.65853     116288  233
## 920                     14.5% 41.73698 -111.83384      48913  764
## 921                     20.2% 41.06022 -111.97105      70790  480
## 922                     61.6% 40.52189 -111.93910      40921  897
## 923                      3.9% 40.88939 -111.88077      43023  856
## 924                      5.1% 40.76078 -111.89105     191180  124
## 925                      6.6% 40.66689 -111.88799      48612  768
## 926                     77.4% 40.52467 -111.86382      45285  821
## 927                     13.3% 41.16161 -112.02633      37733  974
## 928                      8.6% 41.22300 -111.97383      84249  375
## 929                     38.4% 40.60967 -111.93910     110077  250
## 930                      2.9% 40.66772 -111.93883      60519  584
## 931                      6.1% 44.47588  -73.21207      42284  870
## 932                     15.0% 38.80484  -77.04692     148892  165
## 933                      9.4% 37.22957  -80.41394      43609  841
## 934                     -4.2% 36.83543  -76.29827      96205  310
## 935                     -6.6% 37.02987  -76.34522     136699  187
## 936                      0.9% 37.08708  -76.47301     182020  130
## 937                     66.0% 39.11566  -77.56360      47673  783
## 938                    -11.0% 36.58597  -79.39502      42907  859
## 939                     10.5% 38.02931  -78.47668      44349  831
## 940                     19.5% 37.41375  -79.14225      78014  423
## 941                     19.5% 38.75095  -77.47527      41705  880
## 942                      5.1% 36.85293  -75.97798     448479   39
## 943                     15.1% 36.76821  -76.28749     230571   91
## 944                      8.2% 37.54072  -77.43605     214114   99
## 945                      3.8% 37.27097  -79.94143      98465  298
## 946                      5.0% 36.85077  -76.28587     246139   81
## 947                     27.1% 38.44957  -78.86892      51395  719
## 948                     33.5% 36.72821  -76.58356      85728  367
## 949                     29.1% 46.21125 -119.13723      76762  432
## 950                     19.1% 47.61038 -122.20068     133992  190
## 951                      2.9% 47.75565 -122.34152      54790  668
## 952                     44.1% 47.61627 -122.03557      50169  742
## 953                     41.7% 47.03426 -122.82319      44919  824
## 954                      9.4% 47.97898 -122.20208     105370  269
## 955                     34.9% 47.30732 -122.22845      74860  447
## 956                     11.7% 46.60207 -120.50590      93257  322
## 957                     54.3% 47.38093 -122.23484     124435  213
## 958                      7.0% 47.65878 -117.42605     210721  102
## 959                     11.8% 47.18538 -122.29290      38609  959
## 960                      1.1% 47.17176 -122.51846      59097  607
## 961                      8.8% 47.32232 -122.31262      92734  324
## 962                     98.5% 46.23958 -119.10057      67599  506
## 963                     87.5% 47.68149 -122.20874      84430  373
## 964                     12.6% 47.67323 -117.23937      91113  335
## 965                     88.4% 47.48288 -122.21707      97003  305
## 966                     14.2% 45.63873 -122.66149     167405  145
## 967                     15.6% 47.60621 -122.33207     652405   21
## 968                      2.9% 47.81065 -122.37736      40727  902
## 969                     12.1% 47.03787 -122.90070      48338  776
## 970                     34.6% 46.28569 -119.28446      52413  700
## 971                     21.8% 48.74908 -122.47815      82631  390
## 972                      4.9% 47.56732 -122.63294      39056  950
## 973                    115.7% 48.05176 -122.17708      63269  552
## 974                     26.0% 47.67399 -122.12151      57530  627
## 975                     56.7% 47.47038 -122.34679      49858  747
## 976                      4.9% 47.25288 -122.44429     203446  107
## 977                     -4.7% 38.34982  -81.63262      50821  725
## 978                     -5.0% 38.41925  -82.44515      49177  760
## 979                     -3.9% 43.75083  -87.71453      48725  766
## 980                      8.0% 43.01168  -88.23148      71016  475
## 981                     -1.9% 43.06057  -88.10648      37999  971
## 982                      4.5% 44.26193  -88.41538      73596  456
## 983                      5.6% 42.68279  -89.01872      63820  545
## 984                     -0.6% 43.01668  -88.00703      60697  582
## 985                     -4.4% 42.72613  -87.78285      78199  421
## 986                     -0.8% 43.80136  -91.23958      51522  716
## 987                      9.5% 42.58474  -87.82119      99889  294
## 988                      8.7% 44.81135  -91.49849      67545  508
## 989                      1.7% 44.95914  -89.63012      39309  945
## 990                      3.6% 42.97640  -88.10842      39834  926
## 991                     15.8% 43.07305  -89.40123     243344   83
## 992                      0.0% 43.04946  -88.00759      47134  795
## 993                      4.8% 42.96140  -88.01259      37159  993
## 994                      5.3% 44.02471  -88.54261      66778  515
## 995                      1.7% 43.77304  -88.44705      42970  857
## 996                      0.3% 43.03890  -87.90647     599164   31
## 997                      1.9% 44.51916  -88.01983     104779  272
## 998                      2.9% 42.50835  -89.03178      36888  999
## 999                     19.9% 42.86663 -106.31308      59628  599
## 1000                    16.9% 41.13998 -104.82025      62448  558
  1. Review the structure of dfNew and explain the columns (aka attributes) in that dataframe.
str(dfNew)
## 'data.frame':    1000 obs. of  8 variables:
##  $ state                   : chr  "Alabama" "Alabama" "Alabama" "Alabama" ...
##  $ Abbreviation            : chr  "AL" "AL" "AL" "AL" ...
##  $ city                    : chr  "Mobile" "Phenix City" "Montgomery" "Decatur" ...
##  $ growth_from_2000_to_2013: chr  "-1.9%" "31.9%" "-0.1%" "3.1%" ...
##  $ latitude                : num  30.7 32.5 32.4 34.6 34.7 ...
##  $ longitude               : num  -88 -85 -86.3 -87 -86.6 ...
##  $ population              : num  194899 37498 201332 55816 186254 ...
##  $ rank                    : chr  "122" "983" "111" "653" ...
#Merging the two data frames added the State and Abbreviation colums to the data set that had the city, population and longitude and latitude data

Step 3: Visualize the data

  1. Plot points (on top of a map of the US) for each city. Have the color represent the population.
library(ggmap)


bb <- c(left = min(dfNew$long),
bottom = min(dfNew$lat),
right = max(dfNew$long),
top = max(dfNew$lat))

map = get_stamenmap(bb, zoom = 4)

ggmap(map)

ggmap(map) +
geom_point(data= dfNew,
aes(x=longitude,y=latitude, color=population))

  1. Add a block comment that criticizes the resulting map. It’s not very good.
#Because the plots are reprenting the color and the population it makes it difficult to truly understand what the map is trying to show

Step 4: Group by State

  1. Use group_by and summarise to make a dataframe of state-by-state population. Store the result in dfSimple.
dfSimple <- dfNew %>%
  group_by(state)%>%
  summarise(total_population = sum(population))
dfSimple
## # A tibble: 51 × 2
##    state                total_population
##    <chr>                           <dbl>
##  1 Alabama                       1279813
##  2 Alaska                         300950
##  3 Arizona                       4691466
##  4 Arkansas                       787011
##  5 California                   27910620
##  6 Colorado                      3012284
##  7 Connecticut                   1239817
##  8 Delaware                       108891
##  9 District of Columbia           646449
## 10 Florida                       7410114
## # … with 41 more rows
  1. Name the most and least populous states in dfSimple and show the code you used to determine them.
summary(dfSimple)
##     state           total_population  
##  Length:51          Min.   :   42284  
##  Class :character   1st Qu.:  569106  
##  Mode  :character   Median : 1327215  
##                     Mean   : 2571224  
##                     3rd Qu.: 2540772  
##                     Max.   :27910620
dfSimple[which.min(dfSimple$total_population),]
## # A tibble: 1 × 2
##   state   total_population
##   <chr>              <dbl>
## 1 Vermont            42284
#vermont
dfSimple[which.max(dfSimple$total_population),]
## # A tibble: 1 × 2
##   state      total_population
##   <chr>                 <dbl>
## 1 California         27910620
#california

Step 5: Create a map of the U.S., with the color of the state representing the state population

  1. Make sure to expand the limits correctly and that you have used coord_map appropriately.
library(ggmap)
us <-map_data("state")
head(us)
##        long      lat group order  region subregion
## 1 -87.46201 30.38968     1     1 alabama      <NA>
## 2 -87.48493 30.37249     1     2 alabama      <NA>
## 3 -87.52503 30.37249     1     3 alabama      <NA>
## 4 -87.53076 30.33239     1     4 alabama      <NA>
## 5 -87.57087 30.32665     1     5 alabama      <NA>
## 6 -87.58806 30.32665     1     6 alabama      <NA>
dfSimple$state <- tolower(dfSimple$state)
head(dfSimple)
## # A tibble: 6 × 2
##   state      total_population
##   <chr>                 <dbl>
## 1 alabama             1279813
## 2 alaska               300950
## 3 arizona             4691466
## 4 arkansas             787011
## 5 california         27910620
## 6 colorado            3012284
combined_data <- merge(us, dfSimple, by.x="region", by.y= 'state')
head(combined_data)
##    region      long      lat group order subregion total_population
## 1 alabama -87.46201 30.38968     1     1      <NA>          1279813
## 2 alabama -87.48493 30.37249     1     2      <NA>          1279813
## 3 alabama -87.52503 30.37249     1     3      <NA>          1279813
## 4 alabama -87.53076 30.33239     1     4      <NA>          1279813
## 5 alabama -87.57087 30.32665     1     5      <NA>          1279813
## 6 alabama -87.58806 30.32665     1     6      <NA>          1279813
ggmap(map) +
geom_polygon(data=combined_data, aes(x= long,y=lat, group=group, fill=total_population),color="black", alpha=0.8,) +
  expand_limits(x=combined_data$long, y=combined_data$lat)